The other thing:
1/ SELECT a, b, c FROM foo();2/ SELECT a FROM foo();
How result (build and) returns function foo() in example 1/ and 2/ ?
It's bad functions if returns same result for both queries -- because in example 2/ is wanted only one columns. IMHO
functionreturning records needs information about wanted result (number of columns, etc).
For example trigger functions has specific information by"CurrentTriggerData" struct. For functions returning records
wecan create special struct too. What?
Karel
-- Karel Zak <zakkr@zf.jcu.cz>http://home.zf.jcu.cz/~zakkr/C, PostgreSQL, PHP, WWW, http://docs.linux.cz,
http://mape.jcu.cz