Re: plpgsql and rowtypes

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dave Trombley <dtrom(at)bumba(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: plpgsql and rowtypes
Date: 2002-01-01 23:23:25
Message-ID: 553.1009927405@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dave Trombley <dtrom(at)bumba(dot)net> writes:
> test'# DECLARE
> test'# tt testtable;

Try
DECLARE
tt testtable%ROWTYPE;

Not sure why plpgsql insists on the explicit marker that a rowtype is
meant, but it does.

I'll fix the documentation to explain this correctly.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dave Trombley 2002-01-01 23:31:08 plpgsql and rowtypes
Previous Message Calvin Dodge 2002-01-01 23:15:48 Re: Access to Postgresql Utility