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
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
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-
-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
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
10 matches
Mail list logo