Re: function returning a row - Mailing list pgsql-novice

From Joe Conway
Subject Re: function returning a row
Date
Msg-id 41C05544.10602@joeconway.com
Whole thread Raw
In response to Re: function returning a row  (Kjetil Haaland <kjetil.haaland@student.uib.no>)
Responses Re: function returning a row  (Michael Fuhr <mike@fuhr.org>)
List pgsql-novice
Kjetil Haaland wrote:
> this i have done, i can return a single value of my own type from the
> function. So now i am wondering, is it possible to return a set of my type?
> If it is possible, how do i do that?
>

I haven't followed this thread from the beginning, but if I understand
correctly, you have a custom scalar type, and you want to return a set
of that type? You should be able to declare the function with
  "RETURNS setof alignres", and then implement it as an SRF. See for
example normal_rand() in contrib/tablefunc.

Joe

pgsql-novice by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: [despammed] \d output to a file
Next
From: Geoffrey
Date:
Subject: Re: \d output to a file