Re: Using GIN indexes on 8.2 - Mailing list pgsql-general

From Alexander Staubo
Subject Re: Using GIN indexes on 8.2
Date
Msg-id 1398D9E0-A964-4F90-B7C8-1024C724401B@purefiction.net
Whole thread Raw
In response to Re: Using GIN indexes on 8.2  (Teodor Sigaev <teodor@sigaev.ru>)
Responses Re: Using GIN indexes on 8.2  (Teodor Sigaev <teodor@sigaev.ru>)
List pgsql-general
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.



pgsql-general by date:

Previous
From: Teodor Sigaev
Date:
Subject: Re: Using GIN indexes on 8.2
Next
From: "Alex Turner"
Date:
Subject: Re: Problem with pg_dump