I would like to use the following query:
SELECT english || '\n' || english || '\x2028' || french AS output FROM
where \x2028 is the hexadecimal code for a soft carriage return.
However, this does not work.
Can anyone help with this problem?
2028 LINE SEPARATOR * may be used to represent this semantic unambiguously
, decimal 8232, hex 0x2028, octal \20050, binary
10000000101000 UTF-8: 0xe2 0x80 0xa8
pgsql-novice by date
|Next:||From: Joyce Gerald-LGJ002||Date: 2010-03-08 21:30:52|
|Subject: 'database cluster initialization failed' in Linux|
|Previous:||From: Scott Marlowe||Date: 2010-03-08 07:33:38|
|Subject: Re: [NOVICE] How to read oracle table's data from postgre|