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])