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 function returning
records needs information about wanted result (number of columns, etc).
For example trigger functions has specific information by
"CurrentTriggerData" struct. For functions returning records we can
create special struct too. What?
Karel
--
Karel Zak <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakkr/
C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
