[Fwd: Re: [ask] Return Query]

thanks Justin, my problem resolved, but i trying to re-create table and function, i'm using PGAdmin III to Create
Script
table and function before delete my table and function, after that I run Create Sript without change my script
and working well

my question is : whether that bug in postgreSQL?


I feel afraid if will happen again like this by itself

thanks before for your help

Note : I'm sory about my english, my english is very bad


Justin wrote:

> 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
>
>
>