undefined | Better HN

0 pointstraxys2y ago0 comments

I had a situation where I'm not really sure I could have used something else than null: I need a value in one of two columns exactly (meaning one is NULL and the other not).

You can build a constraint to check that if it's in the same table, but across tables it seems to be a bit more complex right ?

0 comments

snmx9992y ago

You could have the first column indicate the type of value and the second column the value. If you now have your columns named "a" and "b" you could have the first column named "type" only allowing values "a" or "b" and the second column would be "value" where the actual value is stored.

j / k navigate · click thread line to collapse

0 comments

snmx9992y ago

j / k navigate · click thread line to collapse