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
