Hi,
The excellently detailed Postgres manual, seems to indicate that
the concatenation operator "||" converts the right and left operands of
all base types to text with the exception of boolean which cannot be cast
as any other type. However I find that the conversion of numeric to text
fails with an error mesage indicating that || cannot concatenate text with
numeric. To make the concatenation work, I am forced to explicity cast
numeric with a text(numeric).
Is this correct behaviour consistent with the manual? Also, what
special problems prevent the conversion of boolean to text? We could fix
things so that text(boolean) return the strings TRUE or FALSE depending
on the argument.
Many thanks in advance
Regards,
Gurunandan