On Jan 20, 2006, at 1:45 , Leif B. Kristensen wrote:
That is usual behaviour for RDBMSes. They are case-insensitive if you use ALL_CAPS or small_letters only.
PostgreSQL is case-insensitive in the sense that it down-cases identifiers that are not double-quoted, e.g.,
MYSUPERFIELD -> mysuperfield MySuperField -> mysuperfield mysuperfield -> mysuperfield "MYSUPERFIELD" -> MYSUPERFIELD "MySuperField" -> "MySuperField" "mysuperfield" -> mysuperfield Michael Glaesemann grzm myrealbox com ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org