Account name:
Password
(OpenID?)
(Forgot it?)
Remember Me
You're viewing
emperor
's journal
Create a Dreamwidth Account
Learn More
Interest
Region
Site and Account
FAQ
Email
Reload page in style:
site
light
Matthew's Journal
...does what it says on the tin. Yes/No/Tickybox.
Recent
Calendar
Read
Network
Tags
Memories
Profile
←
→
Yes/No/Tickybox
posted by
emperor
at 03:05pm on 09/09/2009 under
polls
,
silly
Since SQL has not been my friend today...
[
Poll #1455301
]
←
→
There are 8 comments on this entry. (
Reply
.)
(no subject)
posted by
toothycat
at 02:09pm on 09/09/2009
Should that be
True, False and File Not Found
? ;)
[
link
] [
reply
]
(no subject)
posted by
aardvark179.livejournal.com
at 02:16pm on 09/09/2009
Unknown
[
link
] [
parent
] [
reply
]
(no subject)
posted by
emperor
at 02:22pm on 09/09/2009
Tickybox
[
link
] [
parent
] [
reply
]
(no subject)
posted by
aardvark179.livejournal.com
at 02:13pm on 09/09/2009
I hate it when it comes to predicate optimisation, and bug reports from people who don't love it.
[
link
] [
reply
]
(no subject)
posted by
beckyc.livejournal.com
at 02:40pm on 09/09/2009
I boggled when I first was doing excel macros and discovered that there were the visibility options visible, hidden and very hidden.
[
link
] [
reply
]
(no subject)
posted by
didiusjulianus.livejournal.com
at 04:35pm on 09/09/2009
Any kind of logic is all right with me, it's things completely lacking in logic that I'm not generally so keen on :)
[
link
] [
reply
]
(no subject)
posted by
mhoulden.livejournal.com
at 09:48pm on 09/09/2009
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.
[
link
] [
reply
]
(no subject)
posted by
queex.livejournal.com
at 12:22pm on 11/09/2009
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.
[
link
] [
reply
]
July
Sun
Mon
Tue
Wed
Thu
Fri
Sat
1
2
3
1
4
5
6
7
8
9
1
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
(no subject)
(no subject)
(no subject)
(no subject)
(no subject)
(no subject)
(no subject)
(no subject)
> 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.