Cursor declaration - Mailing list pgsql-general

From Nigel Horne
Subject Cursor declaration
Date
Msg-id 1125401666.3446.8.camel@laptop1.home-network2.net
Whole thread Raw
Responses Re: Cursor declaration  (Richard Huxton <dev@archonet.com>)
Re: Cursor declaration  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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.

-Nigel


pgsql-general by date:

Previous
From: Crystle Numan
Date:
Subject: Re: Select gives the wrong results
Next
From: Clodoaldo Pinto
Date:
Subject: Re: update functions locking tables