From: | Andreas Zeugswetter <andreas(dot)zeugswetter(at)telecom(dot)at> |
---|---|
To: | "'Dr(dot) Michael Meskes'" <meskes(at)online-club(dot)de> |
Cc: | "'hackers(at)postgresql(dot)org'" <hackers(at)postgresql(dot)org> |
Subject: | AW: [HACKERS] Declare Cursor question again |
Date: | 1998-08-06 08:52:48 |
Message-ID: | 01BDC129.015FAFF0@zeugswettera.user.lan.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
Informix can't eighter:
informix(at)zeus:/usr/informix> esql hallo.ec
esqlc: "hallo.ec", line 9: Error -33055: The name cur has already been used.
1 error(s) found
I guess the objective has to be: be fast during execution
and therefore a declare is probably better.
Andreas
From | Date | Subject | |
---|---|---|---|
Next Message | Sergey E. Levov | 1998-08-06 08:53:01 | Re: [HACKERS] SPI procedure for removing large objects |
Previous Message | Andreas Zeugswetter | 1998-08-06 08:45:41 | AW: [HACKERS] Large objects names |