Re: small problem updating to 7.2... - Mailing list pgsql-general

From Stephan Szabo
Subject Re: small problem updating to 7.2...
Date
Msg-id 20011107180849.O50937-100000@megazone23.bigpanda.com
Whole thread Raw
In response to small problem updating to 7.2...  (GB Clark II <postgres@vsservices.com>)
List pgsql-general
On Wed, 7 Nov 2001, GB Clark II wrote:

> Hi,
>
> I've got a database that has a column named timestamp.
> Of course is this the same a type and now 7.2 will not allow me to access it
> directly.  Any ideas how I can get to the data until I redesign the schema?
>
> Here is an example from it:
>
> helpshop=# select * from customer as C where C.timestamp = '2001-09-09';
> ERROR:  parser: parse error at or near "timestamp"

It should be enough to double quote timestamp when you want to refer to
the column.



pgsql-general by date:

Previous
From: GB Clark II
Date:
Subject: small problem updating to 7.2...
Next
From: Tom Lane
Date:
Subject: Re: small problem updating to 7.2...