| From: | "Jackson, DeJuan" <djackson(at)cpsgroup(dot)com> |
|---|---|
| To: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>, fmorton(at)base2inc(dot)com |
| Cc: | pgsql-sql(at)postgreSQL(dot)org |
| Subject: | RE: [SQL] Kind of Funny |
| Date: | 1999-01-06 19:32:27 |
| Message-ID: | F10BB1FAF801D111829B0060971D839F5B94D0@cpsmail |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nathan Hand | 1999-01-06 20:49:39 | LIKE query over multiple fields |
| Previous Message | Gene Selkov Jr. | 1999-01-06 16:05:58 | Re: [SQL] placeholders |