[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-sql
Subject:    Re: [SQL] problem with PL/pgSQL
From:       José Soares <jose () sferacarta ! com>
Date:       1999-06-24 12:08:56
[Download RAW message or body]

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'

[prev in list] [next in list] [prev in thread] [next in thread]