Re: function returning a row

Поиск
Список
Период
Сортировка
Искать
От
Kjetil Haaland
Тема
Re: function returning a row
Дата
Msg-id
200502141008.43402.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>
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
Дата:
FAQ