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