pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedUppercase problem with several interfaces
4+ messages / 4 participants
[nested] [flat]
* Uppercase problem with several interfaces
@ 1999-10-29 10:11 Fabio.di.Fabio <Lmib@yahoo.com>
0 siblings, 0 replies; 4+ messages in thread
From: Fabio.di.Fabio @ 1999-10-29 10:11 UTC (permalink / raw)
To: pgsql-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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* RE: [INTERFACES] Uppercase problem with several interfaces
@ 1999-10-29 10:35 Peter Mount <petermount@it.maidstone.gov.uk>
1999-10-29 16:12 ` Re: [INTERFACES] Uppercase problem with several interfaces Sebastien Flacher <sflacher@globalmedia.com>
1999-10-30 13:37 ` Re: [INTERFACES] Uppercase problem with several interfaces Hannu Krosing <hannu@tm.ee>
0 siblings, 2 replies; 4+ messages in thread
From: Peter Mount @ 1999-10-29 10:35 UTC (permalink / raw)
To: 'Fabio.di.Fabio' <Lmib@yahoo.com>; 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@yahoo.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.
>
>
> ************
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [INTERFACES] Uppercase problem with several interfaces
1999-10-29 10:35 RE: [INTERFACES] Uppercase problem with several interfaces Peter Mount <petermount@it.maidstone.gov.uk>
@ 1999-10-29 16:12 ` Sebastien Flacher <sflacher@globalmedia.com>
1 sibling, 0 replies; 4+ messages in thread
From: Sebastien Flacher @ 1999-10-29 16:12 UTC (permalink / raw)
To: ; +Cc: pgsql-interfaces
Hello everybody,
for psql and from the perl interface,
the correct syntax seems to be:
select "field" from "table" where "field"='value';
... with the single quotes to be protected with \ when
the request is sent to the backend from a script
(rather than psql);
Peter Mount wrote:
>
> 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';
>
> >
> > 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.
> >
> >
> > ************
>
> ************
--
Sebastien Flacher
Software Engineer - Network Engineering
sflacher@globalmedia.com
Global Media Corporation
phone: 888.322.2282 - http://www.globalmediacorp.com
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [INTERFACES] Uppercase problem with several interfaces
1999-10-29 10:35 RE: [INTERFACES] Uppercase problem with several interfaces Peter Mount <petermount@it.maidstone.gov.uk>
@ 1999-10-30 13:37 ` Hannu Krosing <hannu@tm.ee>
1 sibling, 0 replies; 4+ messages in thread
From: Hannu Krosing @ 1999-10-30 13:37 UTC (permalink / raw)
To: Peter Mount <petermount@it.maidstone.gov.uk>; +Cc: 'Fabio.di.Fabio' <Lmib@yahoo.com>; pgsql-interfaces
Peter Mount wrote:
>
> 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';
>
Actually it should be
select "Name" from "Services";
single quotes (') ar for strings.
-------------
Hannu
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~1999-10-30 13:37 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-10-29 10:11 Uppercase problem with several interfaces Fabio.di.Fabio <Lmib@yahoo.com>
1999-10-29 10:35 RE: [INTERFACES] Uppercase problem with several interfaces Peter Mount <petermount@it.maidstone.gov.uk>
1999-10-29 16:12 ` Sebastien Flacher <sflacher@globalmedia.com>
1999-10-30 13:37 ` Hannu Krosing <hannu@tm.ee>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox