From: Jarek Pudełko <jarek.pudelko@tech.ceti.pl>
To: pgsql-sql@postgresql.org
Subject: return value of the trigger function
Date: Mon, 10 Jan 2005 15:15:33 +0100
Message-ID: <41E28E05.2040307@tech.ceti.pl> (raw)
Hi
I have big problem with a trigger function.
Defs:
CREATE TABLE foo (id int2, name varchar(20));
foo.id cannot be serial or autoint because it will not be unique.
Now I need a trigger that return foo.id of the inserted record.
INSERT INTO foo VALUES (max(foo.id)+1,'junk');
IMHO the trigger should be:
CREATE TRIGGER tr_get_new_id
AFTER INSERT on foo
ON EACH ROW
EXECUTE PROCEDURE get_new_id();
But I cannot create the function :(
I don't know what type should be input and how about output? trigger or
int2?
TIA,
--
Jarek Pudelko
JP272-RIPE
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jarek.pudelko@tech.ceti.pl
Subject: Re: return value of the trigger function
In-Reply-To: <41E28E05.2040307@tech.ceti.pl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox