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

From Jon Nelson
Subject Re: varchar (no 'N') vs. text
Date
Msg-id AANLkTi=T=xkmX1_rgjjSncRqUWFugqns8A5FCA7LsOT+@mail.gmail.com
Whole thread Raw
In response to Re: varchar (no 'N') vs. text  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Fri, Feb 4, 2011 at 1:18 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Jon Nelson <jnelson+pgsql@jamponi.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 coercions
> are needed.

Are there any performance implications for this dummy coercion?
Especially in joins.


--
Jon

pgsql-general by date:

Previous
From: Carlos Mennens
Date:
Subject: Re: Additional Grants To SuperUser?
Next
From: Dmitriy Igrishin
Date:
Subject: Re: Additional Grants To SuperUser?