Home > mailing lists

The folding of unquoted names to lower case in PostgreSQL is incompatible with the SQL standard - Mailing list pgsql-sql

From	David Delorme
Subject	The folding of unquoted names to lower case in PostgreSQL is incompatible with the SQL standard
Date	March 12, 2003 17:45:05
Msg-id	PMEEIDMOLBOIEHAGBLOPOENFCAAA.ddelorme@dmdelorme.ca Whole thread Raw
List	pgsql-sql

Tree view

I am trying to integrate MapInfo with a postgresql backend.
Problem:
MapInfo query uses both quoted and unquoted statements i.e.
"MAPINFO"."MAPINFO_MAPCATALOG" and mapinfo.mapinfo_mapcatalog
I have a schema called MAPINFO and a table called MAPINFO_MAPCATALOG.
I need to fold unquoted names to uppercase.

I really only need to change this behaviour for this schema.

David Delorme
http://dmdelorme.ca

pgsql-sql by date:

From: Hesham Gowaily
Date: 12 March 2003, 17:45:02
Subject: Execution plan problem

From: August Detlefsen
Date: 12 March 2003, 17:45:06
Subject: Using column alias in WHERE clause?

The folding of unquoted names to lower case in PostgreSQL is incompatible with the SQL standard - Mailing list pgsql-sql

Previous

Next