On Wednesday 01 October 2003 11:32, Daniel Schuchardt wrote:
> Read the docs...
>
> Hm looking towards the doks thats the right behavoir. Also from the
> logical point thats the right behavoir. But I don't like it. The CAST
> should return an empty string in that case (looking from the practical
> standpoint).
Many would (probably will) disagree.
AFAIK in SQL NULLs are typed, so it's perfectly reasonable to have a null
int4, null varchar etc.
--
Richard Huxton
Archonet Ltd