how to return whole table from Function not just the id integer column - Mailing list pgsql-sql

hi ,

how can i return the whole user table from this function not just the id . thanks

CREATE TABLE users(id serial PRIMARY KEY, first_name varchar(10), last_name
varchar(10));

CREATE OR REPLACE FUNCTION new_user(fname varchar, lname varchar)
RETURNS int AS $$
DECLARE r int;
BEGIN  -- custom exception -- lname cannot be empty or NEMO  IF trim(lname) = '' OR lower(lname) = 'nemo' THEN    RAISE EXCEPTION 'bad last_name: "%"', lname;  END IF;  INSERT INTO users(first_name, last_name) VALUES(lname, fname) RETURNING
id INTO r;  RETURN r;
END;
$$ LANGUAGE plpgsql;