Ian Barwick wrote: > but also this: > > func_test=# select bar(1); > bar > ----------- > 139059784 > (1 row) > > What is this number? It often varies from query to query. > Possibly an error-in-disguise because of something to do > with the calling context?
This is an illustration of why the expression SRF API isn't very useful for returning composite types ;) The number is actually a pointer to the result row. There is no way under the expression API to get at the individual columns directly. If you're really curious, see contrib/dblink in 7.2.x for an example of a (ugly) workaround. Joe ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster