ilanco(at)gmail(dot)com wrote:
>     NEW.idxFTI := to_tsvector('simple', encode($x$E$x$||
> NEW.messageblk, 'escape'));
>     
>   

I strongly doubt that this does what you think it does - I would check 
the results if I were you. The $x$E$x$ should almost certainly not be 
there - if you are trying to get E'foo' behaviour, that is purely for 
literals. All you are doing here is to prepend a literal 'E' to your value.

cheers

andrew

In response to

• Re: ERROR: translation failed from server encoding to wchar_t at 2008-01-08 11:49:53 from ilanco

pgsql-hackers by date

Next:	From: Gregory Stark	Date: 2008-01-08 14:13:53
	Subject: Psql command-line completion bug
Previous:	From: ilanco	Date: 2008-01-08 11:49:53
	Subject: Re: ERROR: translation failed from server encoding to wchar_t