Jon Nelson <jnelson+pgsql@xxxxxxxxxxx> 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 coercions are needed. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general