Re: starting on functions (with a bit more succes)

ok, one error fixed: do not combine declare with language 'sql'. When using
declare use 'plpgsql'

now this is accepted:

create FUNCTION createNewClient(clientName varchar, coreURL varchar,vs_ip
varchar, vs_db varchar, vs_connstring varchar, vs_usr_pw
varchar,lifespanUnitLV varchar, lifespan int2 DEFAULT null) RETURNS void
AS $BODY$
declare
aSerial uuid;
lifeSpanUnitPK bigint;

begin


SELECT INTO aSerial
newuuid();

select into lifeSpanUnitPK
tbl_typelistvalues.pkid
from tbl_typelistvalues
join tbl_typelists on tbl_typelistvalues.fk_typelist =
tbl_typelists.pkid
where listvalue = lifespanUnitLV AND typelistname =
'token_lifespan_units';

insert into
tbl_clients(vserver_userpw,vserver_ip,vserver_dbname,vserver_connectionstring,client_name,client_serial,client_core_url,token_lifespan,objptr_token_lifespan_unit)
values
(vs_usr_pw,vs_ip,vs_db,vs_connstring,clientName,aSerial,coreURL,lifespan,lifeSpanUnitPtr);

exception
when others then
raise ;
end;
$BODY$
LANGUAGE plpgsql
CALLED ON NULL INPUT
SECURITY INVOKER
IMMUTABLE;
--------------

Problem is not solved for this:

after BEGIN i would like to use this if then statement:
-----------------
if lifespanUnitLV = '4' then

end if
----------------
This returns an error: Error : ERROR: syntax error at or near "SELECT"
LINE 14: SELECT INTO aSerial
^

It must be something with the IF itself.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/starting-on-functions-with-little-succes-tp4557235p4559069.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.