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))
> @@
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
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
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:
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
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
Title: Nachricht
Hi,
try
contrib/tsearch2
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/
HTH
Hakan
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of HHDirecto.NetSent: Wednesday, September 27,
2006 4:56 PMTo: pgsql-genera
