From: Sebastien Flacher <sflacher@globalmedia.com>
Cc: Psql-interfaces <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] Uppercase problem with several interfaces
Date: Fri, 29 Oct 1999 09:12:34 -0700
Message-ID: <3819C772.A6DCD281@globalmedia.com> (raw)
References: <1B3D5E532D18D311861A00600865478C25E79E@exchange1.nt.maidstone.gov.uk>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: sflacher@globalmedia.com
Subject: Re: [INTERFACES] Uppercase problem with several interfaces
In-Reply-To: <3819C772.A6DCD281@globalmedia.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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