Re: to_tsvector in 8.2.3

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Teodor Sigaev <teodor(at)sigaev(dot)ru>
Cc: richardcraig <richard(at)v3fm(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: to_tsvector in 8.2.3
Date: 2007-03-21 17:05:24
Message-ID: 20070321170524.GB31386@svr2.hagander.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Mar 21, 2007 at 04:25:30PM +0300, Teodor Sigaev wrote:
> I can't reproduce your problem, but I have not Windows box, can anybody
> reproduce that?
>
>
> contrib_regression=# select version();
> version
>
> PostgreSQL 8.2.3 on i386-unknown-freebsd6.2, compiled by GCC gcc (GCC)
> 3.4.6 [FreeBSD] 20060305
> (1 row)
> contrib_regression=# show server_encoding ;
> server_encoding
> -----------------
> UTF8
> (1 row)
>
> contrib_regression=# show lc_collate;
> lc_collate
> ------------
> C
> (1 row)
>
> contrib_regression=# show lc_ctype;
> lc_ctype
> ----------
> C
> (1 row)
>
> contrib_regression=# select to_tsvector('test text');
> to_tsvector
> -------------------
> 'test':1 'text':2
> (1 row)

postgres=# select version();show lc_collate;show lc_ctype;
version

--------------------------------------------------------------------------------
-------------
PostgreSQL 8.3devel on i686-pc-mingw32, compiled by GCC gcc.exe (GCC)
3.4.2 (mi
ngw-special)
(1 row)

lc_collate
------------
C
(1 row)

lc_ctype
----------
C
(1 row)

postgres=# select to_tsvector('test text');
to_tsvector
---------------
'test text':1
(1 row)

(encoding is UTF8 on a fresh database)

//Magnus

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robert James 2007-03-21 17:47:20 pg_dump without psql rights
Previous Message Chris Browne 2007-03-21 17:01:03 Re: SoC Ideas for people looking for projects