| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Oliver Elphick" <olly(at)lfix(dot)co(dot)uk> |
| Cc: | Ketil Malde <ketil(at)ii(dot)uib(dot)no>, 108286(at)bugs(dot)debian(dot)org, pgsql-general(at)postgresql(dot)org, pgsql-odbc(at)postgresql(dot)org |
| Subject: | Re: Re: Bug#108286: case sensitivity in column names |
| Date: | 2001-08-10 13:48:13 |
| Message-ID: | 11812.997451293@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-odbc |
"Oliver Elphick" <olly(at)lfix(dot)co(dot)uk> writes:
> Ketil Malde wrote:
>>>> Notice how it uses mixed case column names here?
> And therefore should have double-quoted them.
Or not double-quoted them --- but it has to be consistent about it.
"FooBar" and FooBar are not the same name according to the SQL standard.
So if you quote column names in the CREATE TABLE command, you have to
quote 'em forevermore. And if not, not.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-08-10 13:49:34 | Re: Subselects running out of memory |
| Previous Message | Ketil Malde | 2001-08-10 13:38:55 | Re: Bug#108286: case sensitivity in column names |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2001-08-10 17:19:14 | KSQO parameter |
| Previous Message | Ketil Malde | 2001-08-10 13:38:55 | Re: Bug#108286: case sensitivity in column names |