Your function have some bugs; 1) The parser doesn't understand keywords like ENDIF but END IF
(two words) 2) You must to use keyword INTO with the select command
try this one instead:
create function addtrafic (text, int8, int2) returns int2 as ' declare boo text; statia alias for $1 ;
traficul alias for $2 ; directia alias for $3 ; begin select statie from trafic into boo where
statie=$1; if not found then insert into trafic (statie) values( $1 ); end if; if
$3< 1 then update trafic set traf_in=traf_in+ $2 where statie= $1;
else update trafic set traf_out=traf_out+ $2 where statie=
$1; end if; return $3 ; end;
' language 'plpgsql';
Tiberiu Craciun ha scritto:
> Part 1.1 Type: Plain Text (text/plain)
> Encoding: quoted-printable
--
______________________________________________________________
PostgreSQL 6.5.0 on i586-pc-linux-gnu, compiled by gcc 2.7.2.3
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Jose'