![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 31 to 32 of 32 total |
![]() |
Mon, Jan 21 2019 4:23 AM | Permanent Link |
Matthew Jones | Roy Lambert wrote:
> I like the idea of null meaning "we haven't put anything in here yet" Indeed - that's what it can be used to mean. The integers are a better example too - if you have three transactions on an account, one is a purchase, one is a refund, and the other is a change of address. Each can have a money paid value. 100, -15, and NULL. Now you can be clear about what you have in the way of financial transactions, without having to be clever about having another column to control whether you include the value or not. I'd hope (and am pretty sure it does) that SQL would average only two rows there, for example. NULL isn't a magic anything, but it makes sense to have it as an option. And indeed, defining a column with a default of an empty string is fine really - why not? You are sort of ignoring the NULLable aspect, while keeping it as an option for other columns. Turning off NULLs means you lose that option. -- Matthew Jones |
Mon, Jan 21 2019 7:14 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | Matthew
Please note that at no time (to the best of my recollection) have I said I don't like the concept of NULL. I'm just arguing against using it for the wrong things (in my view) and pretending an emptystring exists. Roy Lambert |
« Previous Page | Page 4 of 4 | |
Jump to Page: 1 2 3 4 |
This web page was last updated on Wednesday, August 14, 2024 at 03:12 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |