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
