case-sensitivity and the serial type

From: John BEPPU <beppu(at)lineo(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: case-sensitivity and the serial type
Date: 2000-07-14 09:21:49
Message-ID: 20000714032149.H1265@yukari.lineo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I've been using the debian package of postgresql (7.0-release-1)
and I've been able to say something like:

create table blah ( id serial );

Note how serial is all lowercase. I have since compiled
postgresql 7.0.2 on my friends box and installed it in my
home directory so I could play w/ it. I was surprised when
I couldn't build my table w/ the above statement, but if I
were to do:

create table blah ( id SERIAL );

(note how serial is all uppercase, now) it works.

Can anyone explain why this happens? I guess for the time
being, I'll capitalize every instance of 'serial' when I
create tables, but this just got me curious.

thanks!

Browse pgsql-sql by date

  From Date Subject
Next Message John BEPPU 2000-07-14 09:28:39 nevermind...
Previous Message Tom Lane 2000-07-13 18:22:30 Re: update some elements in the array