DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:user-agent:mime-version:to:subject
	:content-type:content-transfer-encoding;
	b=e4rhLh/QDFAnjVg7J/hXAwj/ww79EfSuRXAOC2cXt2ZtijXx+OcNulXTE8/Wd9NK8R
	tJO1lr1HU4j4R+z+bk8+TtUyP5s2ga5yTxARM3m5WrAmqS/YZp55w+WF3pB6XjFe/uY3
	ZNsA2Z1EmQ15SuT8KiTedDAgf5Su8cz39QpAk=
Message-ID: <4D0969C4.5050205@gmail.com>
Date: Wed, 15 Dec 2010 22:22:12 -0300
From: serviciotdf <serviciotdf@gmail.com>
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US;
	rv:1.9.2.13) Gecko/20101208 Thunderbird/3.1.7
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Translate Function PL/pgSQL to SQL92
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hello,

I have a Function in PL/pgSQL and I need to translate it to SQL92, but 
I'm stuck.

###
CREATE OR REPLACE FUNCTION pruebas(varchar, varchar, integer)
RETURNS SETOF personal AS
$delimiter$
BEGIN
PERFORM id from documentos WHERE descripcion = $1;
IF NOT FOUND THEN
     INSERT INTO documentos(descripcion) VALUES($1);
END IF;
INSERT INTO personal(nombre,idtipodocumento,numdoc)
VALUES($2, (SELECT id from documentos WHERE descripcion = $1), $3);
END;
$delimiter$
LANGUAGE plpgsql;
###

Tables

CREATE TABLE documentos
   id serial NOT NULL,
   descripcion character varying(60),
   CONSTRAINT pkdocumentos PRIMARY KEY (id)


CREATE TABLE personal
   id serial NOT NULL,
   nombre character varying(60),
   idtipodocumento smallint NOT NULL,
   numdoc integer,
   CONSTRAINT pkpersonal PRIMARY KEY (id),
   CONSTRAINT fkpdoc FOREIGN KEY (idtipodocumento)
       REFERENCES documentos (id) MATCH SIMPLE
       ON UPDATE CASCADE ON DELETE NO ACTION,
   CONSTRAINT unqnumdoc UNIQUE (idtipodocumento, numdoc)


Thanks and greetings for all

Marcelo