Oracle greatest() and nvl() equivalent?

From: Petter Reinholdtsen <pere(at)hungry(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Oracle greatest() and nvl() equivalent?
Date: 1999-06-30 08:53:03
Message-ID: 199906300853.KAA28867@lee.cc.uit.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


I have the following SQL construct from Oracle. How do I express this
in PostgreSQL 6.5?

SELECT greatest(nvl(max(when_updated),0),
nvl(max(when_inserted),0),
nvl(max(when_marked_for_delete),0))
FROM source_table;

I'm not on this list. Please cc replies to me.
--
##> Petter Reinholdtsen <## | pere(at)td(dot)org(dot)uit(dot)no
O- <SCRIPT Language="Javascript">window.close()</SCRIPT>
http://www.hungry.com/~pere/ | Go Mozilla, go! Go!

Browse pgsql-sql by date

  From Date Subject
Next Message José Soares 1999-06-30 12:08:53 Re: [SQL] begin/end/abort work for sequences?
Previous Message webmaster 1999-06-30 08:10:48 Beginner's headache of joins