Cursor declaration

From: Nigel Horne <njh(at)bandsman(dot)co(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Cursor declaration
Date: 2005-08-30 11:34:27
Message-ID: 1125401666.3446.8.camel@laptop1.home-network2.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Clodoaldo Pinto 2005-08-30 11:39:52 Re: update functions locking tables
Previous Message Crystle Numan 2005-08-30 11:20:31 Re: Select gives the wrong results