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.a...@wien.gv.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@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
