Re: Cursor

The syntax error was running the function while not in a trigger.

The trigger gave null as a return.

The error was "syntax error at or near Open".

Bob

----- Original Message -----
From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Bob Pawley" <rjpawley(at)shaw(dot)ca>
Cc: "Richard Huxton" <dev(at)archonet(dot)com>; "PostgreSQL"
<pgsql-general(at)postgresql(dot)org>
Sent: Tuesday, July 29, 2008 3:30 PM
Subject: Re: [GENERAL] Cursor

> "Bob Pawley" <rjpawley(at)shaw(dot)ca> writes:
>> Qualifying the column was the solution.
>
> Huh. What was the error message you got, exactly? Because it doesn't
> seem like that should have led to a syntax error.
>
> regards, tom lane