varchar (no 'N') vs. text - Mailing list pgsql-general

From Jon Nelson
Subject varchar (no 'N') vs. text
Date
Msg-id AANLkTik8i-hOVQJXQNdBY_fqVRptRYDFdKvQzAAiVxkx@mail.gmail.com
Whole thread Raw
Responses Re: varchar (no 'N') vs. text  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Let's say I have a database with two tables, a and b.
Each has one column.  'a' has a column 't' of type text.  'b' has a
column 'v' of type 'varchar' (no length specified).
If I join the two tables, I see in the plan something that looks like this:

Merge Cond: (a.t = (b.v)::text)

I thought 'character varying' (aka varchar) sans length was an alias
for text. Is it not?


--
Jon

pgsql-general by date:

Previous
From: Carlos Mennens
Date:
Subject: Additional Grants To SuperUser?
Next
From: Robert Fitzpatrick
Date:
Subject: plperl.dll on windows with postgresql 9.0