Re: Entering a character code in a query

I would just like to thank Albe and Jasen for their responses. What an
extraordinary environment Postgres is! Human and computing.

On Tue, Mar 9, 2010 at 1:32 PM, Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>wrote:

> John Gage wrote:
> > I would like to use the following query:
> >
> > SELECT english || '\n' || english || '\x2028' || french AS
> > output FROM vocab_words_translated;
> >
> > where \x2028 is the hexadecimal code for a soft carriage return.
> >
> > However, this does not work.
> >
> > Can anyone help with this problem?
>
> If you have PostgreSQL 8.4 with standard_conforming_strings = on,
> you could write:
>
> english || E'\n' || english || U&'\2028' || french
>
> Otherwise, you have to resort to
>
> english || E'\n' || english || chr(8232) || french
>
> (provided your server_encoding is UTF8).
>
> Yours,
> Laurenz Albe
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>