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!
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 |