Re: PL/pgSQL functions - text / varchar - havy performance - Mailing list 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@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110