Function syntax ?
| От | Ruben Gouveia |
|---|---|
| Тема | Function syntax ? |
| Дата | |
| Msg-id | 51e507b0809091055l2f83eb1dmf983c1e41da46c2a@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: Function syntax ?
Re: Function syntax ? |
| Список | 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';
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';
В списке pgsql-sql по дате отправления: