On Thu, May 10, 2001 at 02:08:56PM -0400, [EMAIL PROTECTED] 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: pa
desc is a keyword - ORDER BY DESC-ending
Robert Creager
StorageTek
INFORMATION made POWERFUL
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>
> I have 7.1
>
> Can someone take a look the following
> and tell me why I'm getting errors?
> I'm completely baffle
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
[EMAIL PROTECTED] wrote:
> I have 7.1
>
> Can someone take a look the f
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,
