Re: function returning a row

Поиск
Список
Период
Сортировка
Искать
От
Kjetil Haaland
Тема
Re: function returning a row
Дата
Msg-id
200502101316.37463.kjetil.haaland@student.uib.no
Ответ на
Список
Дерево обсуждения
function returning a row Kjetil Haaland <kjetil.haaland@student.uib.no>
Re: function returning a row Michael Fuhr <mike@fuhr.org>
Re: function returning a row Kjetil Haaland <kjetil.haaland@student.uib.no>
Re: function returning a row Joe Conway <mail@joeconway.com>
Re: function returning a row Michael Fuhr <mike@fuhr.org>
Re: function returning a row Kjetil Haaland <kjetil.haaland@student.uib.no>
Re: function returning a row Tom Lane <tgl@sss.pgh.pa.us>
Re: function returning a row Kjetil Haaland <kjetil.haaland@student.uib.no>
Re: function returning a row Kjetil Haaland <kjetil.haaland@student.uib.no>
Re: function returning a row Michael Fuhr <mike@fuhr.org>
Re: function returning a row Michael Fuhr <mike@fuhr.org>
Re: function returning a row Kjetil Haaland <kjetil.haaland@student.uib.no>
hello

I have tested my function some more and found out that it is while i am trying 
to return it crashes. If i use a standard type like float it works, but with 
my own type alignres it doesn't. I have used this type as return value in 
other functions before, but not in set returning functions.

When returning a float value, SRF_RETURN_NEXT(funcctx, Float8GetDatum(result)) 
is used. What am i supposed to use for my own type to get the datum value? I 
have tried using PointerGetDatum(result) but then the function crashes.

regards
Kjetil
В списке pgsql-novice по дате отправления
От: Michael Fuhr
Дата:
От: Van Ingen, Lane
Дата:
Сообщение: PL/pgSQL: FOT Loops vs Cursors
FAQ