Aah, perfect. Thanks for the pointer. -Clark
----- Original Message ---- From: Dan Kennedy <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Tuesday, January 30, 2007 10:49:34 PM Subject: Re: [sqlite] NULL always greater? The basic rule is that the result of any comparison involving a NULL value (including comparing against another NULL) is NULL. See the following for the details: http://www.sqlite.org/nulls.html Dan. On Tue, 2007-01-30 at 16:41 -0800, Clark Christensen wrote: > I've read through numerous discussions here about comparing values with null, > and how SQLite functions work with null values, and I thought I understood. > > Now it seems appropriate to use the max(col1, col2) function to find the > latest of two dates (integer Unix times), and some rows will contain null in > one column or the other. But, max() always returns null when one of its args > is null. That just seems backwards :-)) > > FWIW, I'm on 3.3.12 on both Windows and Linux. > > Any help is appreciated. > > Thanks! > > -Clark > > > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
