Re: PL/PGSQL rowtype return pr

From: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
To: "rwickert(at)contextworld(dot)com" <rwickert(at)contextworld(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: PL/PGSQL rowtype return pr
Date: 2007-06-12 15:38:48
Message-ID: 162867790706120838r699206b3ge0025cb677ff3b23@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vincenzo Romano 2007-06-12 15:40:47 Re: INSERT ... RETURNING in v8.2
Previous Message Robert Treat 2007-06-12 14:50:46 Re: When should I worry?