Re: [GENERAL] Fulltext index

2008-11-10 Thread Sam Mason
Before waking up properly, I wrote: > Querying is a bit awkward, but works: > > SELECT * > FROM test > WHERE tsvector_concat( > to_tsvector('english', CASE lang WHEN 'english' THEN text ELSE '' END), > to_tsvector('german', CASE lang WHEN 'german' THEN text ELSE '' END)) > @@

Re: [GENERAL] Fulltext index

2008-11-10 Thread Sam Mason
On Mon, Nov 10, 2008 at 09:14:21AM +0100, Andreas Kraftl wrote: > Am Sat, 08 Nov 2008 09:44:17 +0100 schrieb Andreas Kraftl: > > How can I create a full text index over b? > > thanks for the answers. But nothing matches my problem. I'm not sure what's wrong with Oleg's suggestion--he's the guy wh

Re: [GENERAL] Fulltext index

2008-11-10 Thread Andreas Kraftl
Am Sat, 08 Nov 2008 09:44:17 +0100 schrieb Andreas Kraftl: > How can I create a full text index over b? Hello thanks for the answers. But nothing matches my problem. I read the manual again and decide me for an other way. I change my table that it looks like: lang| text

Re: [GENERAL] Fulltext index

2008-11-08 Thread Tom Lane
Andreas Kraftl <[EMAIL PROTECTED]> writes: > CREATE INDEX idx ON table USING gin( > to_tsvector( > case > when a = 'de' then 'german' > when a = 'en' then 'english' > else 'english' > end > ), b); > This doesn't work. Error Message in german:

Re: [GENERAL] Fulltext index

2008-11-08 Thread Oleg Bartunov
On Sat, 8 Nov 2008, Andreas Kraftl wrote: Hello again, my previous post wasn't answered. I think i told my question wrong :-). I have a table like a| b 'de' | Hallo welt 'en' | Hello world How can I create a full text index over b? use concatenation operator: tsvect

Re: [GENERAL] Fulltext index

2008-11-08 Thread Ivan Sergio Borgonovo
On Sat, 08 Nov 2008 09:44:17 +0100 Andreas Kraftl <[EMAIL PROTECTED]> wrote: > Hello again, > my previous post wasn't answered. I think i told my question > wrong :-). > > I have a table like > a| b > > 'de' | Hallo welt > 'en' | Hello world > > How can I create a full

[GENERAL] Fulltext index

2008-11-08 Thread Andreas Kraftl
Hello again, my previous post wasn't answered. I think i told my question wrong :-). I have a table like a| b 'de' | Hallo welt 'en' | Hello world How can I create a full text index over b? CREATE INDEX idx ON table USING gin( to_tsvector( case w

[GENERAL] FullText index

2008-11-04 Thread Andreas Kraftl
Hello, we have a table where is a column with language ISO code like en, de, ... How can i build the index, depending on this languagecode? >From the manual: to_tsvector([ config regconfig , ] document text) Where is documented what "config regconfig" can be? Thanks Andreas -- Sent via pgsql-

Re: [GENERAL] Fulltext index in postgres?

2006-09-27 Thread Hakan Kocaman
-general@postgresql.orgSubject: [GENERAL] Fulltext index in postgres?I havet to develop an search engine over a postgres table. I know in mysql the fulltext index to do it more quicky than using like % ...There is any like t in postgres?Thanks

[GENERAL] Fulltext index in postgres?

2006-09-27 Thread HHDirecto . Net
I havet to develop an search engine over a postgres table. I know in mysql the fulltext index to do it more quicky than using like % ...There is any like t in postgres?Thanks