Обсуждение: small problem updating to 7.2...

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?

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.

double quotes are your friend:

    C."timestamp" = ...

            regards, tom lane

On Wednesday 07 November 2001 20:34, you wrote:
> double quotes are your friend:
>
>     C."timestamp" = ...
>
>             regards, tom lane
Tom and Stephan,

I did try double quoting, but I was doing it to the entire string
(i.e. "C.timestamp") and that was not working. I was under the impression
 ,wrong here, that the variable was one piece.

Thanks,

GB

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