Re: very odd behavior - Mailing list pgsql-general

From Patrick Welche
Subject Re: very odd behavior
Date
Msg-id 20010510195146.C3314@quartz.newn.cam.ac.uk
Whole thread Raw
In response to very odd behavior  (newsreader@mediaone.net)
List 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 by date:

Previous
From: "Creager, Robert S"
Date:
Subject: RE: very odd behavior
Next
From: "Mitch Vincent"
Date:
Subject: Re: very odd behavior