Declare Cursor question again - Mailing list pgsql-hackers

From Dr. Michael Meskes
Subject Declare Cursor question again
Date
Msg-id 19980805211840.A515@feivel.online-club.de
Whole thread Raw
List pgsql-hackers
Is the following legal:

if (<condition>) {
        exec sql declare cur cursor for
                select name, nr from table where nr < 10;
}
else {
        exec sql declare cur cursor for
                select name, nr from table where nr >= 10;
}


That is declaring one cursor in two different ways? Oracle cannot do that.
We can, though. Shall I disable this (and remove my last changes) or is this
a good feature (as I think it is) and we keep it? Only disadvantage is that
the declare tarnslates into a C statement and is not really a declaration
anymore.

Michael
--
Dr. Michael Meskes        meskes@online-club.de, meskes@debian.org
Go SF49ers! Go Rhein Fire!    Use Debian GNU/Linux!

pgsql-hackers by date:

Previous
From: Roland Roberts
Date:
Subject: How do I find the table that an oid belongs to
Next
From: "Dr. Michael Meskes"
Date:
Subject: Re: [HACKERS] Standards question