| From: | Josh Jore <josh(at)greentechnologist(dot)org> |
|---|---|
| To: | stefan(at)extum(dot)com |
| Cc: | pgsql-sql(at)postgresql(dot)org, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: [SQL] id and ID in CREATE TABLE |
| Date: | 2002-07-19 09:09:09 |
| Message-ID: | Pine.BSO.4.44.0207190407250.2596-100000@kitten.greentechnologist.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
Joshua b. Jore ; http://www.greentechnologist.org
On Sat, 20 Jul 2002 stefan(at)extum(dot)com wrote:
> Why is like this ? Why not letting them upper case if they are not quoted
> ?
>
> stefan
Well.. this is because pgadmin created the attribute as "ID" originally so
for you - it's always been double-quoted to force the case. I never quote
my identifier literals just to avoid all the strange problems (like this)
that happen when you do it. It's just a bad idea.
Josh
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pierre-Yves LANDURE | 2002-07-19 09:17:04 | Problem using ?# with polygon |
| Previous Message | Nigel J. Andrews | 2002-07-19 08:50:52 | Re: Tom, I've got an emergency - please help me |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-07-19 13:31:05 | Re: [SQL] id and ID in CREATE TABLE |
| Previous Message | Martijn van Oosterhout | 2002-07-19 07:20:11 | Re: id and ID in CREATE TABLE |