Triggers question

Поиск
Список
Период
Сортировка
От ycrux@club-internet.fr
Тема Triggers question
Дата
Msg-id mnet1.1141219335.19206.ycrux@club-internet.fr
обсуждение исходный текст
Ответы Re: Triggers question
Список 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 по дате отправления: