k̶̳͉̘e̱̙̻͔̩͍r̙̲̪̖̝̭n̷̺̺̟̭eḷ͍͙͎̹̱̰͞ pa҉̜̳͖n͇̘̳̜̬i̟͉̬͚͟c̫ ‮✨💻☕ is a user on social.wxcafe.net. You can follow them or interact with them if you have an account anywhere in the fediverse. If you don't, you can sign up here.

@cadey @wxcafe you could do that with a nullable Boolean tho

or an integer with a range from 0-2

@Elizafox @wxcafe at the very least this makes things consistent across database applications

@cadey @Elizafox @wxcafe
No no, I can see the case for an unknown value. That's technically still consistent with boolian algibraic functions. I can't see calling an arbitrary thrinary list a boolian value though.

@cadey @wxcafe @Irick You sir have a poor sense of humour

I think you've hung around the functional programmers too long

@Elizafox @cadey @wxcafe
This is the sort of disparage up with which I will not put.

@Elizafox @wxcafe A boolean by any other name would still find this statement to be false.

@Elizafox @cadey @wxcafe
Null isn't unknown though. We don't want to overload its meaning. We're not javascript.

@Elizafox @cadey @wxcafe
O_o erk?
Null implies an absence of value. It's the Null set, yes? It's not, for instance, an uncollapsed qbit: that which has definitive value but has not been observed/recorded. It's a purposeful demarcation of 'absence' to a specific attribute.

But I suppose you could establish alternative interpretation with it.... AND IGNORE THE UNDERPINNINGS OF SET THEORY. D:<

@Elizafox @cadey @wxcafe

Null implies an absence of value. It's the Null set, yes? It's not, for instance, an uncollapsed qbit: that which has possible descrete value but has not been observed/recorded. It's a purposeful demarcation of 'absence' to a specific attribute.

But I suppose you could establish alternative interpretation with it.... AND IGNORE THE UNDERPINNINGS OF SET THEORY. D:<

@Elizafox @cadey @wxcafe
...
What are relational databases but sets? Hell, even graph databases still rely on set operations.

@wxcafe @cadey Many years ago I found that (this prior to the recent de-binarisation of gender), there were five values for "sex" in a major database system: male, female, unknown, indeterminate, and other.

Truth is complicated.

@wxcafe Brilliant Opportunity Of Leveraging Every Available Number

@wxcafe Boolean is a data type with two values. True, false and maybe.

@wxcafe well you got 'true', 'false', 'yes', 'no', and 'maybe so'.

@wxcafe I have personally worked in a scripting language in which booleans could be True, False or -1

@wxcafe -1 in this case actually meant NULL but in booleans, and only in booleans, the tools would show this as "-1"

@wxcafe you've heard of booleans, now get ready for twoleans

@colon_three @wxcafe the value of an awoolean is the number of "o"s at the end

@wxcafe maybe it's a quantum boolean :P

@wxcafe I remember this feeling when finding that one of windows function returned a boolean the value of wich was the number of elements returned or an error code if negative...

@wxcafe A grim reminder to us all what happens when we do not enum.

@wxcafe «It's base 2… doesn't it mean it goes up to 2? Hurr de Durr»

@wxcafe You have 2 possible values: 0, 1, and 2.

@wxcafe Reminds me of the Bit in TRON.
It said YES or NO.
But it also had a NULL state!