varchar (no 'N') vs. text

From: Jon Nelson <jnelson+pgsql(at)jamponi(dot)net>
To: pgsql <pgsql-general(at)postgresql(dot)org>
Subject: varchar (no 'N') vs. text
Date: 2011-02-04 18:45:47
Message-ID: AANLkTik8i-hOVQJXQNdBY_fqVRptRYDFdKvQzAAiVxkx@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robert Fitzpatrick 2011-02-04 19:06:46 plperl.dll on windows with postgresql 9.0
Previous Message Carlos Mennens 2011-02-04 18:27:49 Additional Grants To SuperUser?