Re: [BUGS] bug in 7.4.2, with Handling of Double Quotation Marks

2004-04-05 Thread Tom Lane
Alexander S <[EMAIL PROTECTED]> writes: > Instead I can only insert: > insert into ref_test values (' {here \\"some_text\\"} '); -- but > this is not exactly that i want to have. Unfortunately, that is what the syntax of array literals requires you to say. You might find it easier to work

Re: [BUGS] bug in 7.4.2, with Handling of Double Quotation Marks

2004-04-05 Thread Stephan Szabo
On Wed, 31 Mar 2004, Alexander S wrote: > Bug in 7.4.2.. Concern with handling of Double Quotation Marks ("). > Escape of double quotation marks can't solve the problem. > > -- > CREATE TABLE public.test > ( > my_column varchar NOT NULL, > CONSTRAINT my_primary PRIMARY KEY (my_colum

[BUGS] bug in 7.4.2, with Handling of Double Quotation Marks

2004-04-05 Thread Alexander S
Bug in 7.4.2.. Concern with handling of Double Quotation Marks ("). Escape of double quotation marks can't solve the problem. -- CREATE TABLE public.test ( my_column varchar NOT NULL, CONSTRAINT my_primary PRIMARY KEY (my_column) ) WITHOUT OIDS; --- CREATE TABLE public.ref_tes