Jim Nasby <jna...@enova.com> writes:
> decibel@decina.cashnetusa=# SELECT 'Moo'::regclass;
> ERROR: relation "moo" does not exist at character 8
That's doing what it's supposed to. Compare
regression=# select 'Moo'::regclass;
ERROR: relation "moo" does not exist
LINE 1: select 'Moo'::regclass;
^
regression=# select '"Moo"'::regclass;
ERROR: relation "Moo" does not exist
LINE 1: select '"Moo"'::regclass;
^
The regclass input converter applies the same case-folding rules as
the SQL parser does, ie, fold unless double-quoted.
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
