Philip Warner <[EMAIL PROTECTED]> writes:
> I just noticed that comparing a text to a varchar results in an index not 
> being used without a cast in some circumstances. Given that they have 
> identical internal representations (or so I believe), that seems a little odd.

But they're not the same datatype.

I have been wondering whether we couldn't eliminate the datatype
distinction between text and varchar.  Haven't gotten around to thinking
about it though; the mess in the numeric-datatype world seems higher

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to