On 6/17/06, David M. Cook <[EMAIL PROTECTED]> wrote:
I took it to mean NULL is distinct from any other value, not that each NULL
is distinct from any other NULL.
I believe it means that NULL is distinct even with itself. In other
words, I believe NULL == NULL is false.
On Sat, Jun 17, 2006 at 10:16:47AM -0700, Will Leshner wrote:
> But if NULL is distinct for UNIQUE columns, isn't that the result you
> would expect?
I took it to mean NULL is distinct from any other value, not that each NULL
is distinct from any other NULL.
Why would one want NULL to behave thi
On 6/17/06, David M. Cook <[EMAIL PROTECTED]> wrote:
says that nulls are distinct in a column, but I haven't found that to be the
case (this is a test with 3.3.5)
create table foo (bar text, baz text, unique(bar, baz));
select * from foo;
bar|baz
quux|null
quux|null
quux|null
But
On Thu, Jun 15, 2006 at 02:23:58PM -0500, Jay Sprenkle wrote:
> You might try adding NOT NULL to your column constraints and
> a default to an empty string in the create table.
> I thought UNIQUE implied NOT NULL but I might be
> wrong.
The null handling page
http://sqlite.org/nulls.html
says t
4 matches
Mail list logo
