Re: NULLs: theoretical problems?
From: -CELKO- <jcelko212_at_earthlink.net>
Date: Sat, 11 Aug 2007 21:10:16 -0700
Message-ID: <1186891816.828159.183330_at_57g2000hsv.googlegroups.com>
Date: Sat, 11 Aug 2007 21:10:16 -0700
Message-ID: <1186891816.828159.183330_at_57g2000hsv.googlegroups.com>
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));