chicken-users
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: argument against using '() for null values? ([Chicken-users] DBI)


From: Ozzi
Subject: Re: argument against using '() for null values? ([Chicken-users] DBI)
Date: Wed, 27 Feb 2008 21:53:11 -0600
User-agent: Thunderbird 2.0.0.9 (Macintosh/20071031)

Vectors are currently used in the Postgres egg to represent date-time
values. Not saying it's good, but there it is. (BTW, a dbapi needs
consistent date/time support too...)

In Common Lisp, NIL is the same as '(), and both mean "false". In
Scheme we have an explicit #f. For the same reasons we should have an
explicit #<sql-null>. It is important that (sql-null? (sql-null)) is
#t, and (sql-null? anything-else) is #f.

 Since SQL NULL values are common, I really like the simple null? test. It's 
intuitive.

How is (sql-null?) harder or less intuitive?

It's not harder, but not being able to use null? to test for NULL is counterintuitive in my eyes.

Count me as on the fence I guess, between null void and sql-null.




reply via email to

[Prev in Thread] Current Thread [Next in Thread]