Division
| От | Robert Fitzpatrick |
|---|---|
| Тема | Division |
| Дата | |
| Msg-id | 1131124419.22487.49.camel@columbus.webtent.org обсуждение |
| Ответы |
Re: Division
Re: Division |
| Список | pgsql-general |
I am having a problem gettig a percent via division. Below is the first
part of my trigger function where pct returns 0.00, instead of the
expected 0.50. If I try without dimensions to the numeric variable, I
just get 0. What is the correct way to accomplish the percent?
CREATE OR REPLACE FUNCTION "public"."issue" (varchar) RETURNS numeric
AS'
DECLARE
repar text[];
pct numeric(3,2);
noreps integer;
BEGIN
repar := string_to_array($1,''-'');
noreps := array_upper(repar,1);
pct := 1/noreps;
RETURN pct;
END;
'LANGUAGE 'plpgsql' VOLATILE CALLED ON NULL INPUT SECURITY INVOKER;
bachman=# select issue('AA-BB');
issue
-------
0.00
(1 row)
В списке pgsql-general по дате отправления: