Re: [ask] Return Query

ataherster wrote:
> hai all, i'm trying create function like this
>
> CREATE OR REPLACE FUNCTION penjualan(idcb integer)
> RETURNS SETOF penjualan AS
>
>
> but this function is not work with this error : ERROR: structure of
> query does not match function result type
> CONTEXT: PL/pgSQL function "penjualan" line 6 at RETURN QUERY
>
> on the time i try with other table and working well
>
> thanks for your help
This is because Postgresql does know the structure of the data to be
returned. So the choice either use OUT command like so
http://www.postgresql.org/docs/current/static/plpgsql-declarations.html

Create or Replace Function penjualan(idcb, integer, OUT f1 text, OUT f2
integer) Returns SETOF penjualan AS

Or create a new data type describing the data structure
http://www.postgresql.org/docs/8.3/static/sql-createtype.html

Create Type myTable as ( f1 text, f2 integer)

Create or Replace Function penjualan(idcb, integer) Returns SETOF
myTable AS