double quote handling?

From: "postgresql" <pgsql(at)symcom(dot)com>
To: "PgSQL-SQL" <pgsql-sql(at)postgresql(dot)org>
Subject: double quote handling?
Date: 2002-01-27 15:54:59
Message-ID: 200201271539.g0RFd1l17488@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I am running PG 7.2b5 on a Mac OSX (10.1.2) This is my test box at
home. In the office I run 7.1.3 on SUSE linux.

I did not find in the changes faq any reference to the handling of
double quotes. In my testing at home I noticed that 7.2 was
accepting:

update table set col = 'this is a "test"' where col2 = '1800';

Maybe I was wrong, but I thought I had to escape the double quotes.
Is this a change, or have I been doing a lot of work for naught?

Ted

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Peter Eisentraut 2002-01-27 16:02:33 Re: pltcl build problem on FreeBSD (was: Re: pltlc and
Previous Message Yvo Nelemans 2002-01-27 13:13:48 Re: options for no multiple rows?