When I declare a function with a schema-qualified return type, PgAdmin does
not show the schema in the return type:
Here's what I tell Postgres:
===============================================
CREATE OR REPLACE FUNCTION xxx.packet_data(pg_catalog.numeric, pg_catalog.text) RETURNS setof xxx.data_tbl AS
' select * from axxx.data_view where packet_rec_id = $1 and tag = $2;
' LANGUAGE 'sql' VOLATILE;
=====================================================
Here is what PgAdmin shows (note the change following the RETURNS)
=====================================================
CREATE OR REPLACE FUNCTION xxx.packet_data(pg_catalog.numeric, pg_catalog.text) RETURNS setof data_tbl AS
' select * from axxx.data_view where packet_rec_id = $1 and tag = $2;
' LANGUAGE 'sql' VOLATILE;
---
Michael
