small problem updating to 7.2...

From: GB Clark II <postgres(at)vsservices(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: small problem updating to 7.2...
Date: 2001-11-08 01:08:14
Message-ID: 01110719081407.80779@prime.vsservices.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)VSServices(dot)COM | General Geek
CTHULU for President - Why choose the lesser of two evils?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-11-08 01:27:46 Re: pg_restore
Previous Message Hiroshi Inoue 2001-11-08 00:58:36 Re: ODBC and Native error codes