Search Postgresql Archives

Re: PostgreSQL Gotchas

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, Oct 13, 2005 at 12:21:14PM -0700, Chris Travers wrote:
> >Since the end reward for all this work would be having to read CATALOGS
> >WRITTEN IN ALL UPPER CASE, none of the key developers seem very
> >interested ...
> > 
> >
> Why would this be required?  If an individual developer wants to have a 
> db with folding to uppercase, that developer can easily quote any 
> references to system tables himself.  I don't see why this is a 
> requirement.  "Case sensitivity" is "Case sensitivity" is "Case 
> sensitivity" ...

I think you're slightly missing the point. Most people won't need to
change any queries because unquoted identifiers are case-folded anyway.
Which way doesn't matter, as long as it's consistant. No the main
objection would be this (see below). Does anyone really want this? I'll
take lowercase anyday... (Note, it's not exact, some things aren't SQL
identifiers so would be left alone. But idea is the same.)

TEST=# \l
        List of databases
   Name    |  Owner   | Encoding
-----------+----------+----------
 TEMPLATE0 | POSTGRES | UNICODE
 TEMPLATE1 | POSTGRES | UNICODE
<snip>
(6 rows)

TEST=# \df+ bit    
                                                        List of functions
 Result data type |   Schema   | Name |  Argument data types  |  Owner   | Language | Source code |          Description
------------------+------------+------+-----------------------+----------+----------+-------------+------------------------------
 BIT              | PG_CATALOG | BIT  | BIGINT                | POSTGRES | INTERNAL | BITFROMINT8 | INT8 To BITSTRING
 BIT              | PG_CATALOG | BIT  | BIT, INTEGER, BOOLEAN | POSTGRES | INTERNAL | BIT         | Adjust BIT() to typomod length
 BIT              | PG_CATALOG | BIT  | INTEGER               | POSTGRES | INTERNAL | BITFROMINT4 | INT4 To BITSTRING   
(3 rows)

TEST=# \d website
     Table "PUBLIC.WEBSITE"
  Column   |  Type   | Modifiers 
-----------+---------+-----------
 FILENAME  | TEXT    | 
 TITLE     | TEXT    | 
 PARENT    | TEXT    | 
 HITS      | INTEGER | 
 HIDDEN    | BOOLEAN | 
 HITSMONTH | INTEGER | 
Indexes:
    "WEBSITE_FILENAME" UNIQUE, BTREE (FILENAME)


-- 
Martijn van Oosterhout   <kleptog@xxxxxxxxx>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

Attachment: pgpL1ss25Y0Ho.pgp
Description: PGP signature


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux