SQL command for value comparison - Mailing list pgsql-general

Hi,

I would like to compare 2 attributes before display the result using SQL command

     e.g  new_due_date   old_due_date    result to display
-------------------------------------------------------------------------------------------------
          11 Feb 2001    15 Feb 2001     in
          12 Feb 2001    08 Feb 2001     out


"select decode((new_due_date<old_due_date),'in','out') from XYZ"  will not be
working as decode only compare exact value.

Need your advise and thanks a lot in advance.

Regards,
Patricia