Search Postgresql Archives

How to call SETOF function?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



If I run the following (in either a terminal or the PgAdmin3 Query tool) I get the error:

ERROR: query has no destination for result data
SQL state: 42601
Hint: If you want to discard the results of a SELECT, use PERFORM instead.
Context: PL/pgSQL function "anything_all_udf" line 3 at SQL statement

How am I'm supposed to call the function so that I get the same result as the adhoc query it surrounds?

----

create table anything (
  first serial primary key not null
, second varchar not null
, third timestamp default now() not null
);

insert into anything ( second ) values ( 'row a' );
insert into anything ( second ) values ( 'row b' );
insert into anything ( second ) values ( 'row c' );

CREATE OR REPLACE  FUNCTION anything_all_udf(
) RETURNS setof anything
AS $$ 
BEGIN
select * from anything;
END;
$$ 
LANGUAGE plpgsql;

select * from anything_all_udf( );


Regards,
Iain



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux