Why must the function that a trigger calls return "opaque" ???

From: "Greg Patnude" <GPatnude(at)adelphia(dot)net>
To: pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: Why must the function that a trigger calls return "opaque" ???
Date: 2002-08-29 15:35:42
Message-ID: akle4r$2nq5$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

This seem rather limiting... Suppose I want a trigger that after insert,
returns the currval(sequence) of the newly inserted row automatically
without having to run another query ???

GP

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-08-29 15:42:49 Re: join problem or maybe group :(
Previous Message Olga 2002-08-29 15:29:02 SET TIME ZONE problem

Browse pgsql-sql by date

  From Date Subject
Next Message Thomas F. O'Connell 2002-08-29 16:13:03 the optimizer and exists
Previous Message Bruce Momjian 2002-08-29 15:16:20 Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?