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

From GB Clark II
Subject small problem updating to 7.2...
Date
Msg-id 01110719081407.80779@prime.vsservices.com
Whole thread Raw
Responses Re: small problem updating to 7.2...
Re: small problem updating to 7.2...
List pgsql-general
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"

this worked fine for 7.1.2.

thanks for the help.

GB

--
GB Clark II             | Roaming FreeBSD Admin
gclarkii@VSServices.COM | General Geek
           CTHULU for President - Why choose the lesser of two evils?

pgsql-general by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: LIKE predicate and '\' character
Next
From: Stephan Szabo
Date:
Subject: Re: small problem updating to 7.2...