Обсуждение: very odd behavior

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=>

Thanks everyone for very quick reply.

The reason I found odd was I had
created another able with the same
field name and don't recall having
problems at the time with 7.0.3.
Or did I get the same problem
but I just forgot?  I dumped
and reloaded 7.0.3 table to 7.1
without problem though.

On Thu, May 10, 2001 at 12:26:53PM -0600, Creager, Robert S wrote:
>
> desc is a keyword - ORDER BY DESC-ending
>
> Robert Creager
> StorageTek
> INFORMATION made POWERFUL
>
> > -----Original Message-----
> > From: newsreader@mediaone.net [mailto:newsreader@mediaone.net]
> >
> > 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 a reserved word (descending, ascending, having,  from, etc...),
as in:
select * from foo order by col_a desc;
That is why you need the double quotes.
jeff



Jeff Daugherty
Database Systems Engineer
Great Bridge LLC

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=>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

desc is a keyword - ORDER BY DESC-ending

Robert Creager
StorageTek
INFORMATION made POWERFUL

> -----Original Message-----
> From: newsreader@mediaone.net [mailto:newsreader@mediaone.net]
>
> 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=>

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

desc is a reserved keyword (used in ORDER BY to indicate descending order)..

You can use keywords as field names though you have to put the in quotes (as
you found out!).

-Mitch

----- Original Message -----
From: <newsreader@mediaone.net>
To: <pgsql-general@postgresql.org>
Sent: Thursday, May 10, 2001 2:08 PM
Subject: very odd behavior


> 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=>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>