Re: Q: unexpected result from SRF in SQL
| От | Joe Conway |
|---|---|
| Тема | Re: Q: unexpected result from SRF in SQL |
| Дата | |
| Msg-id | 3CF0FB27.4070806@joeconway.com обсуждение исходный текст |
| Ответ на | Q: unexpected result from SRF in SQL (Ian Barwick <barwick@gmx.net>) |
| Ответы |
Re: Q: unexpected result from SRF in SQL
|
| Список | pgsql-hackers |
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
В списке pgsql-hackers по дате отправления: