Kevin Grittner wrote:
On Wed, Nov 29, 2006 at 1:38 PM, in message
<[EMAIL PROTECTED]>,
Tom Lane <[EMAIL PROTECTED]> wrote:
"Kevin Grittner" <[EMAIL PROTECTED]> writes:
Richard Huxton <dev@archonet.com> wrote:
It's the coalesce that has the problem, not the insert. The
coalesce is
deciding that it's working on text, and so returns text.
It seems like maybe it would be worth overloading the coalesce
method
to handle this particular case differently.
And do what? The only information you have is that all the inputs
are
of unknown type.
I know this is naive, but, what is the type information of the bare
null? Could that be used?
A literal null is "unknown", other literals are "unknown" or
"unknown-numeric" based on quoting iirc.
Hmm - Tom would it be possible to create a cast to unknown, explicitly
cast this coalesce to unknown and let it implicitly cast back to
whatever the column needs?
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
