Ahhh, but I didn't use a double quote identifier. This statement worked fine
for me:
CREATE TABLE atable (
title VARCHAR(20),
name VARCHAR(20),
id SERIAL PRIMARY KEY,
date DATE);
Greg
----- Original Message -----
From: "Joel Burton" <jburton@scw.org>
To: "Gregory Wood" <gregw@com-stock.com>
Cc: "Poul L. Christiansen" <poulc@cs.auc.dk>; "PostgreSQL-General"
<pgsql-general@postgresql.org>
Sent: Thursday, April 26, 2001 2:45 PM
Subject: Re: help with serial type
> 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
>
>