From: | Eric BASIER <basier(at)ipgp(dot)jussieu(dot)fr> |
---|---|
To: | Tiberiu Craciun <tiberiu(at)akela(dot)ro> |
Cc: | pgsql-sql(at)hub(dot)org |
Subject: | Re: [SQL] problem with PL/pgSQL |
Date: | 1999-06-24 11:51:59 |
Message-ID: | 37721BDE.9EF8D903@ipgp.jussieu.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
I insert my response in your text
Tiberiu Craciun wrote:
> I have a table and a function defined like that : create table trafic
> (
> statie text,
> traf_in int8 default 0,
> traf_out int8 default 0
> ); create function addtrafic (text, int8, int2) returns int2 as '
> declare
> statia alias for $1 ;
> traficul alias for $2 ;
> directia alias for $3 ;
> begin
> select * from trafic where statie= $1;
> if not found then
> insert into trafic (statie) values( $1 );
there is an error here ^
the good sentence is : insert into trafic (statie) values ($1) ;
> endif;
> 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;
> endif;
> return $3 ;
> end;
> ' language 'plpgsql'; when I run this SQL : select
> addtrafic('station1',10,0) as test; I got an error like that : NOTICE:
> plpgsql: ERROR during compile of addtrafic near line 20ERROR: parse
> error at or near ";" and i don't know what is wrong, can someone help
> me ?
--
Basier Eric e-mail : basier(at)ipgp(dot)jussieu(dot)fr
http://geoscope.ipgp.jussieu.fr
IPGP Observatoires Sismologie-Volcanologie
4,Place Jussieu 75005 Paris Tour 24-14 4eme Etage Tel 01 44 27 38 96
From | Date | Subject | |
---|---|---|---|
Next Message | Alexander Schneider | 1999-06-24 12:08:12 | Error on Update: ExecCheckPerms-bogus RT relid? |
Previous Message | Tiberiu Craciun | 1999-06-24 10:21:54 | problem with PL/pgSQL |