So exactly what is the order of casts that produces
different results with:
'x' || ' ' || 'x' and 'x' || ' '::char15 || 'x'
Are operators being invoked both (text,text)?
I'm trying to understand the precedence that causes
the different results.
elein
On Tue, Feb 17, 2004 at 10:53:17PM -0500, Tom Lane wrote:
> elein <[EMAIL PROTECTED]> writes:
> > Apparently the ::char is cast to varchar and then text?
>
> No, directly to text, because the || operator is defined as taking text
> inputs. But there's no practical difference between text and varchar on
> this point.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
