Re: case dumbiness in return from functions

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Nico Sabbi <nsabbi(at)officinedigitali(dot)it>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: case dumbiness in return from functions
Date: 2008-01-18 12:43:08
Message-ID: 20080118124308.GB5326@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Nico Sabbi wrote:

> yet I find disturbing that Postgres doesn't make the effort
> to respect the case specified by the user.

It does -- if you quote the names.

> If I created a field
> called "REF" why should Postgres call it "ref" in the output of queries
> if the standard doesn't specify any obligation to convert the name ?

Actually I think the standard mandates case-folding (though to upper
case rather than lower, i.e. the other way around)

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gregory Williamson 2008-01-18 12:45:38 Re: Online Oracle to Postgresql data migration
Previous Message Alban Hertroys 2008-01-18 12:42:50 Re: case dumbiness in return from functions