<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML>
<HEAD><TITLE></TITLE>
<STYLE>
body, table, tr, td, p {margin: 0px 0px 0px 0px}
.bgtabl {BACKGROUND-REPEAT: no-repeat}
</STYLE>
</HEAD>
<BODY bgProperties="fixed" bgcolor="#FFFFFF" background="http://flashimg.club-internet.fr/flash/vide.gif">
Hi All!<br>I want to setup a trigger capable to return more than one record.<br><br>Example (table users contains 10 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 (see above example).<br><br>How can I write such trigger? <br>I mean, what is the correct prototype of this trigger function?<br><br>Thanks in
advance<br>/ycrux<br><br><br><br><br><br><br>
</body></html>
