Re: very odd behavior

Поиск
Список
Период
Сортировка
От Patrick Welche
Тема Re: very odd behavior
Дата
Msg-id 20010510195146.C3314@quartz.newn.cam.ac.uk
обсуждение исходный текст
Ответ на very odd behavior  (newsreader@mediaone.net)
Список pgsql-general
On Thu, May 10, 2001 at 02:08:56PM -0400, newsreader@mediaone.net wrote:
> I have 7.1
>
> Can someone take a look the following
> and tell me why I'm getting errors?
> I'm completely baffled!
> ----------------------------
>
> what=> create table bla(desc text,def text,data text);
> ERROR:  parser: parse error at or near "desc"
> what=> create table bla("desc" text,def text,data text);
> CREATE
> what=>

desc is used to mean descending, as in "order by foo desc". If you enclose
that keyword in quotes, then the parser knows you are using it as a field
name and doesn't wonder about what should be descending..

Cheers,

Patrick

В списке pgsql-general по дате отправления:

Предыдущее
От: "Creager, Robert S"
Дата:
Сообщение: RE: very odd behavior
Следующее
От: "Mitch Vincent"
Дата:
Сообщение: Re: very odd behavior