From: | Peter Mount <petermount(at)it(dot)maidstone(dot)gov(dot)uk> |
---|---|
To: | "'Fabio(dot)di(dot)Fabio'" <Lmib(at)yahoo(dot)com>, Psql-interfaces <pgsql-interfaces(at)postgresql(dot)org> |
Subject: | RE: [INTERFACES] Uppercase problem with several interfaces |
Date: | 1999-10-29 10:35:53 |
Message-ID: | 1B3D5E532D18D311861A00600865478C25E79E@exchange1.nt.maidstone.gov.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
Unless the field names are in quotes, the parser forces them into
lowercase, so in your example, you would change it to:
select 'Name' from 'Services';
Peter
--
Peter Mount
Enterprise Support
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council.
> -----Original Message-----
> From: Fabio.di.Fabio [SMTP:Lmib(at)yahoo(dot)com]
> Sent: 29 October 1999 11:12
> To: Psql-interfaces
> Subject: [INTERFACES] Uppercase problem with several interfaces
>
> Hi,
>
> I've a problem with uppercase letter in table and fields definition.
>
> For example let be a table called 'Services' with fields 'Id' 'Name'
> 'Vaule', now if with PHP or pgaccess ort psql I make this query:
>
> SELECT Name FROM Services;
>
> I got this:
>
> ERROR: attribute 'name' not found.
>
> what is wrong with my configuration?
>
> ciao,
> Fabio.
>
>
> ************
From | Date | Subject | |
---|---|---|---|
Next Message | SAKAIDA | 1999-10-29 10:37:23 | pgbash-1.2.1 released |
Previous Message | Fabio.di.Fabio | 1999-10-29 10:11:40 | Uppercase problem with several interfaces |