Michael Meskes <[EMAIL PROTECTED]> writes: > On Thu, May 24, 2007 at 04:07:27PM -0400, Tom Lane wrote: >> I'd be interested to see where you draw that conclusion, since >> (a) PREPARE statements of that form are not in the standard, and >> (b) DECLARE CURSOR is clearly defined as taking a <query expression>.
> Sorry, should have been more precise. I was talking about embedded SQL > standard. Just look for "dynamic cursors". Oh, I see what you're looking at. But my point here is that this version of PREPARE has zip to do with ours: it seems more akin to plpgsql's EXECUTE, since AFAICT you are supposed to give it a string value that then gets parsed as a SQL statement. Also it lacks any way to define parameters for the statement. > I could also keep my old simultaing code for this special case, which is > probably the best way to do it. Yeah, I think keeping this version of PREPARE on the ecpg side is probably best. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster