RE: [SQL] Kind of Funny - Mailing list pgsql-sql

From Jackson, DeJuan
Subject RE: [SQL] Kind of Funny
Date
Msg-id F10BB1FAF801D111829B0060971D839F5B94D0@cpsmail
Whole thread Raw
List pgsql-sql
> > Not thinking, as I often tend to do, I created a table named "order"
> > and was confused to find the following query does not work:
> >
> > select * from order;
> >
> > I recognize that my name selection is questionable, but shouldn't
> > this still work?
>
> No.  Keywords are not over-loadable, as they are in Pascal,
> and to do it
> is a real pain because the parser can't determine right away
> what it is.

But you can get at it if you quote your table name:
 select * from "order";

    -DEJ

pgsql-sql by date:

Previous
From: "Gene Selkov Jr."
Date:
Subject: Re: [SQL] placeholders
Next
From: Nathan Hand
Date:
Subject: LIKE query over multiple fields