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