|
Hi All! I want to setup a trigger capable to return more than one record. Example (table users contains 10 records): CREATE FUNCTION get_users() RETURNS SOME_TYPE AS ' BEGIN return (SELECT * FROM users); ' LANGUAGE 'plpgsql'; I can't figure out the correct Postgres type for SOME_TYPE (see above example). How can I write such trigger? I mean, what is the correct prototype of this trigger function? Thanks in advance /ycrux |
