Thread: Kind of Funny

Kind of Funny

From
"Frank Morton"
Date:
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?



Re: [SQL] Kind of Funny

From
Bruce Momjian
Date:
> 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.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026