Re: function returning a row
От | Kjetil Haaland |
---|---|
Тема | Re: function returning a row |
Дата | |
Msg-id | 200502141008.43402.kjetil.haaland@student.uib.no обсуждение исходный текст |
Ответ на | Re: function returning a row (Michael Fuhr <mike@fuhr.org>) |
Список | pgsql-novice |
Hi again Thanks a lot! That was the hole problem. Was using an old function that i was extending to return a set, and had forgoten that part. Now it works! -Kjetil On Friday 11 February 2005 11:09, Michael Fuhr wrote: > On Thu, Feb 10, 2005 at 01:16:37PM +0100, Kjetil Haaland wrote: > > 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. > > I was just looking at the code you posted here: > > http://archives.postgresql.org/pgsql-novice/2005-01/msg00371.php > > About 20 lines above the call to SRF_RETURN_NEXT(), you allocate > memory and assign it to "result", but then you never do anything > with that variable before trying to return it. It probably contains > garbage, which could be a problem if it's a variable-length type > since the first 4 bytes are supposed to contain the length of > the data.
В списке pgsql-novice по дате отправления: