From: | Ben Chobot <bench(at)silentmedia(dot)com> |
---|---|
To: | pgsql-general General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: text vs. varchar |
Date: | 2010-07-21 16:07:56 |
Message-ID: | 0FE2174F-612E-4B21-8756-E539AB2B4619@silentmedia.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Jul 21, 2010, at 9:05 AM, Thom Brown wrote:
> On 21 July 2010 16:58, Ben Chobot <bench(at)silentmedia(dot)com> wrote:
>> Is there any difference between "text" and "varchar" data types? (Not varchar(n), just varchar.) I can't see a different from the manual page, but I'm wondering about index usage or something similarly subtle.
>> --
>
> Here's what Tom Lane had to say on the matter when I asked previously:
>
> "There is some potential overhead from using varchar instead of text
> because of the extra dummy cast nodes that are likely to be present in
> your query expressions (since all the native functions are declared to
> take/return text, not varchar). In most cases I'd think you'd be
> hard-put to measure any difference though."
Thanks, this is precisely what I was looking for.
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Browne | 2010-07-21 16:41:29 | Re: pg_dump-restore concurrency |
Previous Message | Thom Brown | 2010-07-21 16:05:00 | Re: text vs. varchar |