Re: to_tsvector in 8.2.3 - Mailing list pgsql-general

From Magnus Hagander
Subject Re: to_tsvector in 8.2.3
Date
Msg-id 20070321170524.GB31386@svr2.hagander.net
Whole thread Raw
In response to Re: to_tsvector in 8.2.3  (Teodor Sigaev <teodor@sigaev.ru>)
Responses Re: to_tsvector in 8.2.3  (Teodor Sigaev <teodor@sigaev.ru>)
List 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


pgsql-general by date:

Previous
From: Chris Browne
Date:
Subject: Re: SoC Ideas for people looking for projects
Next
From: Tom Lane
Date:
Subject: Re: best way to kill long running query?