Re: So what's null then if it's not nothing?
From: Hugo Kornelis <hugo_at_pe_NO_rFact.in_SPAM_fo>
Date: Thu, 24 Nov 2005 23:44:54 +0100
Message-ID: <4agco1hep795rmle3utnegjvqpr9ci1hf7_at_4ax.com>
INSERT INTO People (Name, Birthday)
VALUES ('Hugo Kornelis', NULL)
INSERT INTO People (Name, Birthday)
VALUES ('Frank Hamersley', '19980706')
Date: Thu, 24 Nov 2005 23:44:54 +0100
Message-ID: <4agco1hep795rmle3utnegjvqpr9ci1hf7_at_4ax.com>
On Thu, 24 Nov 2005 12:28:46 GMT, FrankHamersley wrote:
(snip)
>Where it gets more interesting is if you throw the following at the RM
>(Pick will have no trouble AFAICT).
>
><People><Person><Name>Hugo Kornelis</Name></Person>
><Person><Name>Frank
>Hamersley</Name><Birthday>19980706</Birthday></Person></People>
Hi Frank,
In RM, the debate is still going on the "correct" way to represent this.
In SQL's interpretation of RM, the solution is simple:
CREATE TABLE People (Name CHARACTER VARYING (100) NOT NULL,
Birthday DATE, PRIMARY KEY (Name) )
INSERT INTO People (Name, Birthday)
VALUES ('Hugo Kornelis', NULL)
INSERT INTO People (Name, Birthday)
VALUES ('Frank Hamersley', '19980706')
BTW, aren't you a bit young for the explicit content of this group? :-)
Best, Hugo
-- (Remove _NO_ and _SPAM_ to get my e-mail address)Received on Thu Nov 24 2005 - 23:44:54 CET