On Fri, 14 Mar 2003, Andrew Sullivan wrote:
> On Wed, Mar 12, 2003 at 10:30:19AM -0700, scott.marlowe wrote:
> > It's a hackish kluge, but not as big of one as what MapInfo would appear
> > to be :-)
>
> To be fair, the SQL spec requires that unquoted strings be folded to
> upper case, so it's really PostgreSQL's violation of the spec that is
> biting here.
True, very true. While mapinfo would be better had they picked one case /
quoting methodology and stuck to it, the lack of a fold_to_upper setting
or something similar in postgresql is a glaring flaw givin that folding to
lower is against spec, not just doing something a certain way because no
one bothered to define it.
Any chance a patch to set a GUC for case folding would get applied?