On Tue, Mar 9, 2010 at 1:32 PM, Albe Laurenz <laurenz.albe@xxxxxxxxxx> wrote:
John Gage wrote:If you have PostgreSQL 8.4 with standard_conforming_strings = on,
> 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?
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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general