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'