Re: [GENERAL] Postgres automatically inserts chr(13) whenever chr(10) is inserted

2006-03-03 Thread Tom Lane
Dragan Matic <[EMAIL PROTECTED]> writes: > create table sample(column_sample varchar(500)) > insert into sample(column_sample) values('this is first row of text' || > chr(10) || 'this is second row of text') > Now, instead of just inserting chr(10), postgres inserts chr(13) + > chr(10). Postgre

Re: [GENERAL] Postgres automatically inserts chr(13) whenever chr(10) is inserted

2006-03-03 Thread Michael Fuhr
On Fri, Mar 03, 2006 at 08:47:00AM +0100, Dragan Matic wrote: > create table sample(column_sample varchar(500)) > > insert into sample(column_sample) values('this is first row of text' || > chr(10) || 'this is second row of text') > > Now, instead of just inserting chr(10), postgres inserts chr(

[GENERAL] Postgres automatically inserts chr(13) whenever chr(10) is inserted

2006-03-02 Thread Dragan Matic
create table sample(column_sample varchar(500)) insert into sample(column_sample) values('this is first row of text' || chr(10) || 'this is second row of text') Now, instead of just inserting chr(10), postgres inserts chr(13) + chr(10). Is there a way to avoid this? Database is on a linux ser