Skip site navigation (1) Skip section navigation (2)

Re: Cursor

From: "Bob Pawley" <rjpawley(at)shaw(dot)ca>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Richard Huxton" <dev(at)archonet(dot)com>,"PostgreSQL" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Cursor
Date: 2008-07-29 22:40:07
Message-ID: 002201c8f1cc$0d1e6fa0$6401a8c0@owner (view raw, whole thread or download thread mbox)
Lists: pgsql-general
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".


----- 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" 
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 

In response to

pgsql-general by date

Next:From: ChristopheDate: 2008-07-29 22:46:55
Subject: Re: Cursor
Previous:From: Tom LaneDate: 2008-07-29 22:30:06
Subject: Re: Cursor

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group