Re: [SQL] problem with PL/pgSQL

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'