On Mon, Sep 25, 2006 at 14:59:46 +0200,
  Harald Armin Massa <[EMAIL PROTECTED]> wrote:
> Asaf,
> 
> SQL-92 states that identifiers [for dictionary objects] are limited to 128
> characters and are case-insensitive (unless delimited by double quotes),
> because they are automatically translated into uppercase by the system.

Note that Postgres actually lowercases unquoted names instead of uppercasing
them. This difference can be significant.

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match

Reply via email to