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 reached end of trigger procedure without RET

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 reached end of trigger procedure without RET

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

2011-01-25 Thread Adelo Herrero
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 crea

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

2011-01-25 Thread Adelo
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 reached end of trigger procedure without RET

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

2011-01-25 Thread Tom Lane
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 reached end of trigger procedure without RETURN > CONTEXT: PL/pgSQL function "ventas_imp_a

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

2011-01-25 Thread Adelo
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 crea

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 Adelo Herrero Pérez
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

[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