Re: character varying == text?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Reid Thompson" <Reid(dot)Thompson(at)ateb(dot)com>
Cc: "Scott Marlowe" <smarlowe(at)g2switchworks(dot)com>, armtuk(at)gmail(dot)com, "CSN" <cool_screen_name90001(at)yahoo(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: character varying == text?
Date: 2005-09-19 20:38:50
Message-ID: 29530.1127162330@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Reid Thompson" <Reid(dot)Thompson(at)ateb(dot)com> writes:
> is this the expected result? i.e. in the past was the result incorrect?
> or is there a configuration param that controls this?

Yes, yes, and no. You could change the pg_cast entry for char-to-text
if you wanted, but then you would run into the other unpleasant cases
that prompted us to change it in the first place.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2005-09-19 20:47:08 Re: character varying == text?
Previous Message Tom Lane 2005-09-19 20:35:51 Re: Problems with vacuumdb