| From: | Thomas Lockhart <lockhart(at)fourpalms(dot)org> |
|---|---|
| To: | Dwayne Miller <dwayne-miller(at)home(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Time as keyword |
| Date: | 2002-01-08 17:00:03 |
| Message-ID: | 3C3B2593.881BA851@fourpalms.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> Did time become a keyword in 7.2? 7.1.3 allowed it as a column name...
> 7.2 rejects it.
Yes. We now support SQL99 time and timestamp precision, which require
that TIME(p) be a type specification. So there are parts of the grammar
which cannot easily fit "time" anymore.
You could/should use the SQL99 list of reserved words as a guide for
which keywords to *not* use, even though some of them are currently
accepted as, for example, column names. In the meantime, you can
double-quote the column name if you really need it to stay "time".
- Thomas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-01-08 17:05:52 | Re: postgresql 7.2b4 bug |
| Previous Message | Bruno Wolff III | 2002-01-08 16:23:38 | Re: Default permissions of system catalogs |