Re: [GENERAL] Using GIN indexes on 8.2

2006-11-11 Thread Robert Treat
On Friday 10 November 2006 14:41, Jeff Davis wrote: On Fri, 2006-11-10 at 20:39 +0300, Teodor Sigaev wrote: Use @, @ operations instead of @ and ~ Look for discussions in -hackers for reasons of changing names Ah, many thanks. How about updating those web pages? :) Now they are in

Re: [GENERAL] Using GIN indexes on 8.2

2006-11-11 Thread Oleg Bartunov
On Sat, 11 Nov 2006, Robert Treat wrote: On Friday 10 November 2006 14:41, Jeff Davis wrote: On Fri, 2006-11-10 at 20:39 +0300, Teodor Sigaev wrote: Use @, @ operations instead of @ and ~ Look for discussions in -hackers for reasons of changing names Ah, many thanks. How about updating

[GENERAL] Using GIN indexes on 8.2

2006-11-10 Thread Alexander Staubo
Two questions about GIN on 8.2. There's not much documentation about GIN, but this should be possible: create table foo (values text[]); create index foo_values_index on foo using gin (text); However, this then fails saying the operator @ does not exist: select * from foo where values

Re: [GENERAL] Using GIN indexes on 8.2

2006-11-10 Thread Teodor Sigaev
Alexander Staubo wrote: Two questions about GIN on 8.2. There's not much documentation about GIN, but this should be possible: create table foo (values text[]); create index foo_values_index on foo using gin (text); However, this then fails saying the operator @ does not exist:

Re: [GENERAL] Using GIN indexes on 8.2

2006-11-10 Thread Alexander Staubo
On Nov 10, 2006, at 16:16 , Teodor Sigaev wrote: Alexander Staubo wrote: Two questions about GIN on 8.2. There's not much documentation about GIN, but this should be possible: create table foo (values text[]); create index foo_values_index on foo using gin (text); However, this then

Re: [GENERAL] Using GIN indexes on 8.2

2006-11-10 Thread Teodor Sigaev
Use @, @ operations instead of @ and ~ Look for discussions in -hackers for reasons of changing names Ah, many thanks. How about updating those web pages? :) Now they are in core: http://developer.postgresql.org/pgdocs/postgres/functions-array.html Pls, why don't you use tsearch2 with GIN?

Re: [GENERAL] Using GIN indexes on 8.2

2006-11-10 Thread Jeff Davis
On Fri, 2006-11-10 at 20:39 +0300, Teodor Sigaev wrote: Use @, @ operations instead of @ and ~ Look for discussions in -hackers for reasons of changing names Ah, many thanks. How about updating those web pages? :) Now they are in core: