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
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster