Postgres Pro
Downloads
Home   >   mailing lists

Re: plpgsql and rowtypes - Mailing list pgsql-general

From Tom Lane
Subject Re: plpgsql and rowtypes
Date
Msg-id 553.1009927405@sss.pgh.pa.us
Whole thread Raw
In response to plpgsql and rowtypes  (Dave Trombley <dtrom@bumba.net>)
List pgsql-general
Tree view 
Dave Trombley <dtrom@bumba.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

pgsql-general by date:

Previous
From: Dave Trombley
Date:
Subject: plpgsql and rowtypes
Next
From: Dave Trombley
Date:
Subject: Re: plpgsql and rowtypes