return resultset

[gomathilakshmi]

Hi,

I am trying to return a resultset from a function and not sure how to do it but below is the function I created.

create or replace function sp_servicer_pie chart_testing()
returns varchar
as
$$
select top 10 * from data where r='xxx'
$$
language sql immutable;

when executing it getting the below error:
Final SELECT must return exactly one column.

Can some one help me?

thanks.

[rski]

I guess you are looking for

return setof <type>

see here http://www.postgresql.org/docs/8.4/s...xfunc-sql.html

Which postgres do you use, I don't think there is a top clause in select statements in postgres (it is in mssql).

[gomathilakshmi]

Well, I am using ParAccel which supports pgsql.

[rski]

It doesn't matter, the answer is use "return setof"