Re: help with serial type - Mailing list pgsql-general

From Joel Burton
Subject Re: help with serial type
Date
Msg-id Pine.LNX.4.21.0104261445110.1139-100000@olympus.scw.org
Whole thread Raw
In response to Re: help with serial type  ("Gregory Wood" <gregw@com-stock.com>)
List 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@scw.org>
Director of Information Systems, Support Center of Washington


pgsql-general by date:

Previous
From: "Gregory Wood"
Date:
Subject: Re: help with serial type
Next
From: will trillich
Date:
Subject: Re: crypt(table.field) ?