Andrew Sullivan wrote:
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.

Really? Well, if I'm wrong, I'm wrong. Wouldn't be the first time.


Have any explanation as to why that function is so slow?

--
Bill Moran
Potential Technologies
http://www.potentialtech.com


---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to