Re: [GENERAL] Entering a character code in a query

2010-03-09 Thread John Gage
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 wrote: > John Gage wrote: > > I would like to use the following query: > > > > SELECT english || '\n' || english || '\x

Re: [GENERAL] Entering a character code in a query

2010-03-09 Thread Albe Laurenz
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 p