thanks Tom Lane, my problem resolved, I'm trying to re-create my table and function, and this working well
Tom Lane wrote:
ataherster <ataherster@xxxxxxxxxxx> writes:
... 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
This looks like a known limitation in plpgsql: it's not very good with
rowtypes that contain dropped columns. Have you dropped some columns
in table PENJUALAN? If so, try remaking the table from scratch.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
