AW: [HACKERS] Declare Cursor question again

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

Responses

Browse pgsql-hackers by date

  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