Yes/No/Tickybox

[emperor]

Since SQL has not been my friend today...

[Poll #1455301]

Comments

[toothycat]

Should that be True, False and File Not Found? ;)

[aardvark179.livejournal.com]

Unknown

[emperor]

Tickybox

[aardvark179.livejournal.com]

I hate it when it comes to predicate optimisation, and bug reports from people who don't love it.

[beckyc.livejournal.com]

I boggled when I first was doing excel macros and discovered that there were the visibility options visible, hidden and very hidden.

[didiusjulianus.livejournal.com]

Any kind of logic is all right with me, it's things completely lacking in logic that I'm not generally so keen on :)

[mhoulden.livejournal.com]

Of course the only sensible answer is yes and no. There are many times when I've thought SQL should have a MAYBE operator to go with LIKE and SOUNDEX, but I keep wanting to SELECT UNTO things.

[queex.livejournal.com]

I meant to say- if you think SQL is bad, R uses an inconsistent ternary logic model. Witness:

> NA & TRUE
[1] NA
> tmp <- c(1,2,3,NA)
> tmp>=3
[1] FALSE FALSE TRUE NA
> tmp[tmp>=3]
[1] 3 NA

Yes, that's right, the array selection syntax treats NA as TRUE.