Re: very odd behavior

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)