Re: [GENERAL] Cursor declaration

2005-08-30 Thread Tom Lane
Nigel Horne <[EMAIL PROTECTED]> writes: > I can't get passed this message: > 'Cannot mix placeholder styles "$1" and ":foo"' There's no such message anywhere in the Postgres sources. I suppose it must be coming from whatever client-side library you are using (which you didn't say).

Re: [GENERAL] Cursor declaration

2005-08-30 Thread Richard Huxton
Nigel Horne wrote: How do I declare a cursor in a stored procedure if that cursor contains a WHERE which depends on the argument given to that stored procedure? I can't get passed this message: 'Cannot mix placeholder styles "$1" and ":foo"' The message doesn't give a useful line number, so I

[GENERAL] Cursor declaration

2005-08-30 Thread Nigel Horne
How do I declare a cursor in a stored procedure if that cursor contains a WHERE which depends on the argument given to that stored procedure? I can't get passed this message: 'Cannot mix placeholder styles "$1" and ":foo"' The message doesn't give a useful line number, so I don't even know which