Seref Arikan <serefari...@gmail.com> writes: > I want to call a function using a column of a table as the parameter and > return the parameter and function results together. > The problem is, when the function returns an empty row my select statement > that uses the function returns an empty row as well.
This function isn't actually returning an empty row; it's returning no rows, which is possible because RETURNS TABLE is really RETURNS SETOF some-record-type. It's not entirely clear what you're trying to accomplish, so the first thing is to get clear on that. Perhaps you want it to always return one row? If so, don't use the TABLE notation (just list some OUT parameters instead). If you actually do want it to return zero rows, then the problem is not with the function but with the query you're using it in. Set-returning functions in a SELECT's targetlist are often a bad idea. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general