Re: plpgsql arrays

From: justin <justin(at)emproshunts(dot)com>
To: Matthew Wakeling <matthew(at)flymine(dot)org>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-performance(at)postgresql(dot)org
Subject: Re: plpgsql arrays
Date: 2009-04-07 15:23:59
Message-ID: 49DB700F.8020108@emproshunts.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Matthew Wakeling wrote:
> What would be the syntax for putting a single row from a cursor into a
> variable? I have tried:
>
> FETCH INTO left left_cursor;
>
> which says syntax error, and
>
> left = FETCH left_cursor;
>
> which gives the error 'ERROR: missing datatype declaration at or near
> "="'
>
> Matthew
>

Have to declare Left variable as record data type declaration part of
the function

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Matthew Wakeling 2009-04-07 15:33:30 Re: plpgsql arrays
Previous Message Matthew Wakeling 2009-04-07 15:18:41 Re: plpgsql arrays