Jon Nelson <jnelson+pgsql(at)jamponi(dot)net> writes:> I thought 'character varying' (aka varchar) sans length was an alias> for text. Is it not?
It has the same behavior, but it is a distinct type, so dummy coercionsare needed.
regards, tom lane