Content-Type: text/plain;
  charset="iso-8859-1"
From: Mike Rylander <miker@n2bb.com>
Reply-To: miker@n2bb.com
Organization: N2 Broadband
To: Rodrigo Gesswein <rodri@chilesat.net>, pgsql-sql@postgresql.org
Subject: Re: new max function
Date: Fri, 17 Oct 2003 17:32:50 -0400
User-Agent: KMail/1.4.3
References: <Pine.LNX.4.56.0310171510400.6271@pluton.chilepac.com>
In-Reply-To: <Pine.LNX.4.56.0310171510400.6271@pluton.chilepac.com>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Message-Id: <200310171732.50292.miker@n2bb.com>


Here's mine:

CREATE FUNCTION max2 (INTEGER,INTEGER) RETURNS INTEGER
  LANGUAGE SQL AS
  'SELECT CASE WHEN $1 > $2 THEN $1 ELSE $2 END';

This returns:

database=# select max2(1,2);
 max2 
------
    2
(1 row)

database=# select max2(3,1);
 max2 
------
    3
(1 row)


On Friday 17 October 2003 02:13 pm, Rodrigo Gesswein wrote:
> Hello!
>
>    I'm looking for a function to calculate the max value from two numbers,
> something like max2(a,b) with a,b int
>
>    Does anyone have the trick ?
>
>    Thank you in advance..
>
> Rodrigo!
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly

-- 
Mike Rylander