subdir = contrib/intarray

top_builddir = ../..

include$(top_builddir)/src/Makefile.global

SO_MAJOR_VERSION= 1

SO_MINOR_VERSION= 0

overrideCPPFLAGS:= -I$(srcdir)$(CPPFLAGS) -DPGSQL71

overrideCPPFLAGS+= -I$(srcdir) -DPGSQL71

OBJS= _int.o

$(NAME).sql:$(NAME).sql.in

sed's,MODULE_PATHNAME,$(libdir)/$(shlib),g'$<>$@

sed-e's:MODULE_PATHNAME:$(libdir)/$(shlib):g'<$<>$@

.PHONY: submake

submake:

$(MAKE) -C$(top_builddir)/src/test/regress pg_regress

installcheck: submake

$(top_builddir)/src/test/regress/pg_regress _int

check:

@echo"'$(MAKE) check' is not supported."

@echo"Do '$(MAKE) install', then '$(MAKE) installcheck' instead."

@echo"'make check' is not supported."

@echo"Do 'make install', then 'make installcheck' instead."

install: all installdirs install-lib

$(INSTALL_DATA)$(srcdir)/README.intarray$(docdir)/contrib

$(INSTALL_DATA)$(NAME).sql$(datadir)/contrib

installdirs:

$(mkinstalldirs)$(docdir)/contrib$(datadir)/contrib$(libdir)

uninstall: uninstall-lib

rm -f$(docdir)/contrib/README.intarray$(datadir)/contrib/$(NAME).sql

rm -f$(docdir)/contrib/README.$(NAME)$(datadir)/contrib/$(NAME).sql

cleandistcleanmaintainer-clean: clean-lib

rm -f$(OBJS)$(NAME).sql

rm -f*.so y.tab.c y.tab.h$(OBJS)$(NAME).sql

rm -rf results

rm -f regression.diffs regression.out

rm -rf results tmp_check log

rm -f regression.diffs regression.out regress.out run_check.out

ifeq ($(PORTNAME), win)

rm -f regress.def

dependdep:

$(CC) -MM$(CFLAGS)*.c>depend

ifeq (depend,$(wildcard depend))

include depend

This is an implementation of RD-tree data structure using GiST interface

of PostgreSQL. It has built-in lossy compression - must be declared

in index creation - with (islossy). Current implementation has index support

for one-dimensional array of int4's.

in index creation - with (islossy). Current implementation provides index

support for one-dimensional array of int4's - gist__int_ops, suitable for

small and medium size of arrays (used on default), and gist__intbig_ops for

indexing large arrays (we use superimposed signature with length of 4096

bits to represent sets).

All work was done by Teodor Sigaev (teodor@stack.net) and Oleg Bartunov

(oleg@sai.msu.su). See http://www.sai.msu.su/~megera/postgres/gist

for additional information.

-- create indices

CREATE unique index message_key on message ( mid );

CREATE unique index message_section_map_key2 on message_section_map (sid, mid );

CREATE INDEX message_rdtree_idx on message using gist ( sections ) with ( islossy );

CREATE INDEX message_rdtree_idx on message using gist ( sectionsgist__int_ops) with ( islossy );

-- select some messages with section in 1 OR 2 - OVERLAP operator

select message.mid from message where message.sections && '{1,2}';