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 fails saying the operator "@" does not exist: select * from foo where values @ '{hello, world}'Use @>, <@ operations instead of @ and ~ Look for discussions in -hackers for reasons of changing names
Ah, many thanks. How about updating those web pages? :)
Pls, why don't you use tsearch2 with GIN?
Perhaps -- is there any documentation on this? Alexander. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
