Re: PostgreSQL Gotchas - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: PostgreSQL Gotchas
Date
Msg-id 200510161937.56978.peter_e@gmx.net
Whole thread Raw
In response to Re: PostgreSQL Gotchas  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: PostgreSQL Gotchas
List pgsql-general
Tom Lane wrote:
> > Note to implementor: In 'SELECT 1 as "Title"', the quoted string
> > should not be lowercased, even if you are lowercasing everything
> > else...
>
> You don't get to have that, I think, because the lexer is not context
> aware.  It's not clear to me why it's a good idea anyway.

This is used to create pretty column headers in table output.  We'd
surely get criticism if this no longer worked.

I guess you could get around that if you leave the case-folding in the
lexer as is but instead make the nameeq function case insensitive.
This is sort of the way the Windows file system works (I think).  (And
we know that *never* leads to problems... :-/)

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

pgsql-general by date:

Previous
From: Matthew
Date:
Subject: Re: PostgreSQL Gotchas
Next
From: Tom Lane
Date:
Subject: Re: Long running update