Received: from kvikk.uit.no (kvikk.Uit.No [129.242.4.32]) by hub.org (8.9.3/8.9.3) with ESMTP id EAA65449 for ; Wed, 30 Jun 1999 04:53:10 -0400 (EDT) (envelope-from pere@lee.cc.uit.no) Received: from joseph.cc.uit.no (joseph.Cc.Uit.No [129.242.6.242]) by kvikk.uit.no (8.8.8/8.8.8) with ESMTP id KAA11633; Wed, 30 Jun 1999 10:53:04 +0200 (METDST) Received: from lee.cc.uit.no (pere@lee.Cc.Uit.No [129.242.6.46]) by joseph.cc.uit.no (8.8.8/8.8.8) with ESMTP id KAA26313; Wed, 30 Jun 1999 10:53:03 +0200 (METDST) Received: (from pere@localhost) by lee.cc.uit.no (8.8.7/8.8.7) id KAA28867; Wed, 30 Jun 1999 10:53:03 +0200 Date: Wed, 30 Jun 1999 10:53:03 +0200 Message-Id: <199906300853.KAA28867@lee.cc.uit.no> To: pgsql-sql@postgresql.org Subject: Oracle greatest() and nvl() equivalent? From: Petter Reinholdtsen Reply-to: Petter Reinholdtsen 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@td.org.uit.no O- http://www.hungry.com/~pere/ | Go Mozilla, go! Go!