From: | Jeff Daugherty <jdaugherty(at)greatbridge(dot)com> |
---|---|
To: | newsreader(at)mediaone(dot)net |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: very odd behavior |
Date: | 2001-05-10 18:51:34 |
Message-ID: | 3AFAE336.8020906@greatbridge.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)mediaone(dot)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(at)postgresql(dot)org)
From | Date | Subject | |
---|---|---|---|
Next Message | Patrick Welche | 2001-05-10 18:51:46 | Re: very odd behavior |
Previous Message | newsreader | 2001-05-10 18:50:55 | Re: very odd behavior |