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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alexander S <sasha(at)in(dot)crimea(dot)ua>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-bugs(at)postgresql(dot)org
Subject: Re: bug in 7.4.2, with Handling of Double Quotation Marks
Date: 2004-04-06 05:07:25
Message-ID: 19390.1081228045@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-general

Alexander S <sasha(at)in(dot)crimea(dot)ua> 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 with the ARRAY[] constructor syntax.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message PostgreSQL Bugs List 2004-04-06 12:35:19 BUG #1127: ALTER SEQUENCE bug
Previous Message Paul Tillotson 2004-04-06 01:47:25 Re: Renaming a table leaves orphaned implicit sequences which

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2004-04-06 07:47:07 Re: pg_autovacuum won't make on FreeBSD
Previous Message Tom Lane 2004-04-06 04:50:30 Re: set timestamp oddness