Tom Lane, 08.04.2010 10:59:
Thomas Kellerer<spam_ea...@gmx.net> writes:
CREATE OR REPLACE FUNCTION get_employees(name_pattern varchar)
RETURNS TABLE(id integer, full_name text)
AS
$$
BEGIN
RETURN QUERY
SELECT id, first_name||' '||last_name
FROM employee
WHERE last_name LIKE name_pattern ||'%';
END
$$
LANGUAGE plpgsql;
I get one row returned which is correct, but the ID column is null
(but should be 1).
Don't name the parameter the same as the table column ...
regards, tom lane
I knew it was something simple I overlooked ;)
Thanks for the quick response.
Regards
Thomas
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql