Re: PL/PGSQL rowtype return pr - Mailing list pgsql-general

From Pavel Stehule
Subject Re: PL/PGSQL rowtype return pr
Date
Msg-id 162867790706120838r699206b3ge0025cb677ff3b23@mail.gmail.com
Whole thread Raw
In response to Re: PL/PGSQL rowtype return pr  (rwickert@contextworld.com)
List pgsql-general
>
> i can't do
>
> declare
> vals default_vals%rowtype
> begin
> select get_defaults_vals() into vals;
>
> x1 := default_vals.a1;

try
SELECT INTO vals * FROM get_defaults_vals()

Pavel

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: INSERT ... RETURNING in v8.2
Next
From: Vincenzo Romano
Date:
Subject: Re: INSERT ... RETURNING in v8.2