Re: "The tuple structure of a not-yet-assigned record is indeterminate."

From: "A B" <gentosaker(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: "The tuple structure of a not-yet-assigned record is indeterminate."
Date: 2008-06-30 11:57:22
Message-ID: dbbf25900806300457u3d3d1b35l5e94d5690470b0e9@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Sure, declare your result like my example:
>
> test=# create or replace function ab() returns setof record as $$declare r record; begin select into r 1,2;return next r;end;$$language plpgsql;

Unfortunatly I have not the luxury of creating the record with a
single SELECT command.
Isn't there a way around this problem? I really do not want to try to
write it as a single SELECT command. There must be a way of telling it
what structure the record will have?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2008-06-30 12:00:23 Re: Postgresql 8.3 Installer issue
Previous Message A. Kretschmer 2008-06-30 11:46:39 Re: "The tuple structure of a not-yet-assigned record is indeterminate."