Re: NULLs: theoretical problems?

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)
> AS
> VALUES (CAST (NULL AS INTEGER),CAST (NULL AS REAL), CAST (NULL AS
> DATE));
>
> There are several other place where you need this.
>

Meaning

CREATE VIEW Foobar (a INTEGER, b REAL, c DATE) AS
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.

-- 
Eric