Re: PL/pgSQL functions - text / varchar - havy performance

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: PL/pgSQL functions - text / varchar - havy performance
Date: 2003-08-29 15:01:51
Message-ID: 20030829150151.GI19388@libertyrms.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, Aug 29, 2003 at 10:46:44AM -0400, Bill Moran wrote:
>
> Postgres has to convert the text to a varchar before it can actually
> do anything. It's possible (though I'm not sure) that it has to
> do the conversion with each record it looks at.

It does? According to the docs, varchar is just syntactic sugar for
text. In fact, text and varchar() are supposed to be exactly the
same.

A

--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Stephan Szabo 2003-08-29 15:02:26 Re: bad estimates
Previous Message Bill Moran 2003-08-29 14:46:44 Re: PL/pgSQL functions - text / varchar - havy performance