Re: [SQL] Translate Function PL/pgSQL to SQL92

2010-12-17 Thread serviciotdf
, idtipodocumento, numdoc ) SELECT $2, ( SELECT id FROM documentos WHERE descripcion = $1 ), $3; $delimiter$ LANGUAGE SQL; ### Thanks Filip! Marcelo El 16/12/10 08:17, Filip Rembiałkowski escribió: 2010/12/16 serviciotdf servicio...@gmail.com mailto:servicio...@gmail.com Hello, I have a Function

[SQL] Translate Function PL/pgSQL to SQL92

2010-12-15 Thread serviciotdf
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