Received: from zeus.houstoncellular.com (zeus.houstoncellular.com [206.109.152.194]) by hub.org (8.9.1/8.9.1) with ESMTP id OAA17439 for ; Thu, 3 Dec 1998 14:24:12 -0500 (EST) (envelope-from YoungblG@houstoncellular.com) Received: by SCORPEXC1.houstoncell.com with Internet Mail Service (5.5.2232.9) id ; Thu, 3 Dec 1998 13:23:41 -0600 Message-ID: <2B9713A99045D211BB4E0008C75668692EA712@SCORPEXC1.houstoncell.com> From: Greg Youngblood To: "'Sferacarta Software'" , "'PostgreSQL SQL List'" Subject: RE: Re[2]: [SQL] Please help: How to determine largest of two num bers in a query? Date: Thu, 3 Dec 1998 13:23:28 -0600 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2232.9) Content-Type: text/plain; charset="iso-8859-1" Many many thanks.. This is exactly what I was looking for. I must be totally blind... Where can I find a list of the functions Postgres already has.. I'm sure there has to be a way.. -----Original Message----- From: Sferacarta Software [mailto:sferac@bo.nettuno.it] Sent: Thursday, December 03, 1998 6:39 AM To: Greg Youngblood; David Hartwig; 'PostgreSQL SQL List' Subject: Re[2]: [SQL] Please help: How to determine largest of two numbers in a query? PostgreSQL has already these built-in funcions (those used on aggregate MIN/MAX): int2 |int2larger |int2 int2 |larger of two int2 |int2smaller |int2 int2 |smaller of two int4 |int4larger |int4 int4 |larger of two int4 |int4smaller |int4 int4 |smaller of two int8 |int8larger |int8 int8 |larger of two int8 |int8smaller |int8 int8 |smaller of two exemple: SELECT int4larger(3,10) int4larger ---------- 10 (1 row) -Jose'-