thanks pavel...that worked! I like the simplicity of your first suggestion.
On Tue, Sep 9, 2008 at 11:05 AM, Pavel Stehule <[EMAIL PROTECTED]>wrote: > try > > create or replace function fcn_max_dt(p_dt timestamp without time zone, > p_dt2 timestamp without time zone) > returns imestamp without time zone as $$ > select greatest($1,$2); > $$ language sql; > > or > > begin > return greatest(p_dt, p_dt2); > end; > $$ language plpgsql; > > or > begin > if p_dt > p_dt2 then > return p_dt; > else > return p_dt2; > end if; > end; > $$ language sql; > > plpgsql is scripting language and almost is better minimalize number > of statements in function. > > Regards > Pavel Stehule > > 2008/9/9 Ruben Gouveia <[EMAIL PROTECTED]>: > > 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'; > > > > > > >
