Re: NULLs: theoretical problems?

Try this for the casting of NULLs to data types:

CREATE VIEW Foobar (a, b, c)
AS
VALUES (CAST (NULL AS INTEGER),CAST (NULL AS REAL), CAST (NULL AS DATE)); There are several other place where you need this. Received on Sat Aug 11 2007 - 23:10:16 CDT