Re: Problem with function returning a result set

Thomas Kellerer <spam_eater@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