small problem updating to 7.2...

Поиск
Список
Период
Сортировка
От GB Clark II
Тема small problem updating to 7.2...
Дата
Msg-id 01110719081407.80779@prime.vsservices.com
обсуждение исходный текст
Ответы Re: small problem updating to 7.2...  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Re: small problem updating to 7.2...  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Hiroshi Inoue
Дата:
Сообщение: Re: LIKE predicate and '\' character
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: small problem updating to 7.2...