Re: NULLs: theoretical problems?
Date: Sun, 12 Aug 2007 16:17:17 +0100
On 2007-08-12, -CELKO- <jcelko212_at_earthlink.net> wrote:
> Try this for the casting of NULLs to data types:
> CREATE VIEW Foobar (a, b, c)
> VALUES (CAST (NULL AS INTEGER),CAST (NULL AS REAL), CAST (NULL AS
> There are several other place where you need this.
CREATE VIEW Foobar (a INTEGER, b REAL, c DATE)
VALUES (NULL, NULL, NULL); I'm not sure the former should even be allowed, and you would only think of it if you assumed that NULL was a value - as you might have gathered, my opinion is that it is not.
-- EricReceived on Sun Aug 12 2007 - 17:17:17 CEST