>Richard Huxton <dev@xxxxxxxxxxxx> writes: >> [* Actually, I think NULLs are typed in SQL, which means you should be >> able to get type violations. ] > >I'm pretty sure the entire construct is illegal per a strict reading of >the SQL spec --- the spec only allows NULL to appear in contexts where a >datatype can be assigned to it immediately. Honestly I cannot say this info changes too much for me (other DBMSs I use as backend handle this untyped NULLs), though the situation is clarified. Thanks a lot. -- Best regards Ilja Golshtein ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly