Greg Stark <st...@enterprisedb.com> writes:
> On Wed, Mar 4, 2009 at 12:34 PM, Emmanuel Cecchet <m...@asterdata.com> wrote:
>> This is problematic in situations where the output of the cast is involved
>> in some later join which returns incorrect results because of the extra
>> double quotes surrounding the table name. Is there a way to override the
>> default behavior to have a consistent quoted or non-quoted result?
> regclass's output format is intended for human readers, not for
> joining against text columns. Why would you need to be joining between
> regclass and text anyways?
The quoting behavior is the *least* of your problems if you're trying to
do that. Are you aware of how it works vis-a-vis search_path? Have you
thought about what will happen when you rename a table?
Use plain oids or regclass values, not a text column, if you are trying
to store table identities.
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
