Function syntax ?

From: "Ruben Gouveia" <rubes7202(at)gmail(dot)com>
To: pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: Function syntax ?
Date: 2008-09-09 17:55:28
Message-ID: 51e507b0809091055l2f83eb1dmf983c1e41da46c2a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Does this syntax look correct? Can anyone think of a better way to write
this?

This function will accept two timestamp parameters and determine the highest
of the two?

create or replace function fcn_max_dt(p_dt timestamp without time zone,
p_dt2 timestamp without time zone)
returns timestamp without time zone as $$
DECLARE
v_dt timestamp without time zone;
v_dt2 timestamp without time zone;

BEGIN
v_dt := p_dt;
v_dt2 := p_dt2;

if v_dt >= v_dt2 then
return v_dt;
else
return v_dt2;
end if;

END;
$$ LANGUAGE 'plpgsql';

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Pavel Stehule 2008-09-09 18:05:34 Re: Function syntax ?
Previous Message Lennin Caro 2008-09-09 14:36:44 Re: PL/pgSQL function syntax question?