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" <[EMAIL PROTECTED]>
To: "Gregory Wood" <[EMAIL PROTECTED]>
Cc: "Poul L. Christiansen" <[EMAIL PROTECTED]>; "PostgreSQL-General"
<[EMAIL PROTECTED]>
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 <[EMAIL PROTECTED]>
> Director of Information Systems, Support Center of Washington
>
>
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
