Re: [SQL] Control reached end of trigger procedure without RETURN

2011-01-25 Thread MoNiLlO
El 25/01/2011 16:06, Tom Lane escribió: > MoNiLlO writes: >> When I launch one insert returns error: >> I put the function and the returned error. >> CREATE OR REPLACE FUNCTION ventas_det_a_ventas_imp() >> RETURNS trigger AS >> ... >> ERROR: control r

Re: [SQL] Control reached end of trigger procedure without RETURN

2011-01-25 Thread MoNiLlO
El 25/01/2011 16:06, Tom Lane escribió: > MoNiLlO writes: >> When I launch one insert returns error: >> I put the function and the returned error. >> CREATE OR REPLACE FUNCTION ventas_det_a_ventas_imp() >> RETURNS trigger AS >> ... >> ERROR: control r

Re: [SQL] Control reached end of trigger procedure without RETURN

2011-01-25 Thread MoNiLlO
El 24/01/2011 19:19, Andrej escribió: > And, since the list is in English - please translate? I'm sorry, I started writing and the language ... :-( I have a function that is triggered in a trigger whose purpose is, create a record in another table or update and return the id of the record creat

[SQL] Control reached end of trigger procedure without RETURN

2011-01-22 Thread MoNiLlO
Buenos días: Tengo una función que se dispara en un trigger cuya finalidad es; crear un registro en otra tabla o actualizarlo y devolviendo el id del registro creado/modificado para guardarlo en la tabla desde la que se llama. Intentaré explicarlo mejor: tablaA --> Es la que dispara el