Triggers question - Mailing list pgsql-general

From ycrux@club-internet.fr
Subject Triggers question
Date
Msg-id mnet1.1141219335.19206.ycrux@club-internet.fr
Whole thread Raw
Responses Re: Triggers question  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
Hi All!<br />I want to setup a trigger capable to return more than one record.<br /><br />Example (table users
contains10 records):<br /><br />CREATE FUNCTION get_users() RETURNS <br />SOME_TYPE AS '<br />BEGIN<br />       return
(SELECT* FROM users);<br />' LANGUAGE 'plpgsql';<br /><br />I can't figure out the correct Postgres type for SOME_TYPE
(seeabove example).<br /><br />How can I write such trigger? <br />I mean, what is the correct prototype of this
triggerfunction?<br /><br />Thanks in advance<br />/ycrux<br /><br /><br /><br /><br /><br /><br /> 

pgsql-general by date:

Previous
From: Roman Neuhauser
Date:
Subject: Re: majordomo unmaintained, postmaster emails ignored?
Next
From: Alvaro Herrera
Date:
Subject: Re: [SQL] regarding grant option