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 don't even know which line it's complaining about.
Difficult to say - perhaps the source of the function would help. You don't actually mention what language you're using even.
However, I'd look for anywhere you're using ":varname" since that isn't valid plpgsql.
Then, I'd look at the OPEN ... CURSOR ... EXECUTE form of cursor opening (see manuals for details).
-- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
