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 по дате отправления:

Предыдущее
От: dim
Дата:
Сообщение: Re: plpgsql
Следующее
От: "Rodolfo J. Paiz"
Дата:
Сообщение: Re: Converting interval to numeric?