PostgreSQL function returns all records

Question

How to modify existing function to return all rows from table sd_users?

 CREATE OR REPLACE FUNCTION getusers()
      RETURNS sd_users AS
    $BODY$
    DECLARE
      groups sd_users;
    BEGIN
        SELECT * INTO groups FROM sd_users;
        RETURN groups;

    END;
    $BODY$
      LANGUAGE plpgsql VOLATILE
      COST 100;
    ALTER FUNCTION getusers()
      OWNER TO postgres;

Invoke the function code:

  SELECT getusers()

This code returns only first record, how to make it to return all records?

Clodoaldo Neto · Accepted Answer · 2014-06-26 11:28:45Z

3

You are looking for setof. And it can be plain SQL in instead of plpgsql

create or replace function getusers()
returns setof sd_users as $body$
    select * from sd_users;
$body$ language sql stable

edited Jun 26, 2014 at 11:28

answered Jun 25, 2014 at 15:35

Clodoaldo Neto

127k30 gold badges251 silver badges274 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PostgreSQL function returns all records

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related