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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
