| From: | Joel Burton <jburton(at)scw(dot)org> |
|---|---|
| To: | Gregory Wood <gregw(at)com-stock(dot)com> |
| Cc: | "Poul L(dot) Christiansen" <poulc(at)cs(dot)auc(dot)dk>, PostgreSQL-General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: help with serial type |
| Date: | 2001-04-26 18:45:53 |
| Message-ID: | Pine.LNX.4.21.0104261445110.1139-100000@olympus.scw.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, 26 Apr 2001, Gregory Wood wrote:
> > I don't know if you can name a column "date" because I think it's a
> > reserved word.
>
> Oddly enough, it *does* work (at least on my version of 7.1), although I
> would recommend against doing it if for no other reason than it's confusing.
If you wrap them in double-quotes, you can use most reserved words as
system identifiers. But I wouldn't -- some cheesy client implementation
might choke on them, and better to not find that out later.
--
Joel Burton <jburton(at)scw(dot)org>
Director of Information Systems, Support Center of Washington
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joel Burton | 2001-04-26 18:53:18 | Re: Re: Need for newbie friendly docs (was Newbie struggling...) |
| Previous Message | Jie Liang | 2001-04-26 18:38:21 | random rows |