Hi List,
we are converting from another sql db and I need some assistance on an error
with this function:
---------------------------------------------------
create FUNCTION createNewClient(clientName varchar, coreURL varchar,
vs_ip varchar, vs_db varchar, vs_connstring varchar, vs_usr_pw varchar,
lifespanUnitLV int2, lifespan int2 DEFAULT null) RETURNS void
AS $BODY$
declare
aSerial uuid;
lifeSpanUnitPK bigint;
begin
if lifespanUnitLV <> 4 and lifespan is null then
raise exception null_value_not_allowed using hint = 'Lifespan cannot be
null for a lifespanUnitLV different from 4';
end if
set aSerial = select newuuid();
set lifeSpanUnitPK = select 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';
if lifeSpanUnitPK is null then
raise exception null_value_not_allowed using hint = 'Illegal value for
lifespanUnitLV';
end if
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 sql
CALLED ON NULL INPUT
SECURITY INVOKER
IMMUTABLE;
-----------------------------------------------------
This is rejected by the parser with error:
Error : ERROR: syntax error at or near "uuid"
LINE 5: aSerial uuid;
I am sure this is something basic that I am missing and sure would like to
get some guidance with this issue.
tia,
Bart
^
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/starting-on-functions-with-little-succes-tp4557235p4557235.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.