Extend PL/pgSQL

Started by Demise Garrousteover 16 years ago4 messages
#1Demise Garrouste
b.pijoulat@tele2.fr

<div id="_htmlarea_default_style_" style="font:10pt arial,helvetica,sans-serif">Hello,<br><br><div style="text-align:
left;" id="result_box" dir="ltr">
I am in workplacement in a company and I have to make a migration
from one database to PostGreSQL. Nevertheless, the migration is not possible, because I don't have the
GOTO
instruction. I know this is a bad practice, however, I wanted to know
if it's possible to implement this feature. If it's possible, I wonder if a developer could add this feature. Thank you
in advance, send me an
email if you have an answer.</div><br></div>

#2Laurent Laborde
kerdezixe@gmail.com
In reply to: Demise Garrouste (#1)
Re: Extend PL/pgSQL

On Tue, Apr 21, 2009 at 9:09 AM, Demise Garrouste <b.pijoulat@tele2.fr> wrote:

Hello,

I am in workplacement in a company and I have to make a migration from one
database to PostGreSQL. Nevertheless, the migration is not possible, because
I don't have the GOTO instruction. I know this is a bad practice, however, I
wanted to know if it's possible to implement this feature. If it's possible,
I wonder if a developer could add this feature.

Sure ! Here it is : http://tinyurl.com/anel

Thank you in advance, send me an email if you have an answer.

yw :)

--
F4FQM
Kerunix Flan
Laurent Laborde

#3Pavel Stehule
pavel.stehule@gmail.com
In reply to: Laurent Laborde (#2)
Re: Extend PL/pgSQL

Hello

2009/4/21 Laurent Laborde <kerdezixe@gmail.com>:

On Tue, Apr 21, 2009 at 9:09 AM, Demise Garrouste <b.pijoulat@tele2.fr> wrote:

Hello,

I am in workplacement in a company and I have to make a migration from one
database to PostGreSQL. Nevertheless, the migration is not possible, because
I don't have the GOTO instruction. I know this is a bad practice, however, I
wanted to know if it's possible to implement this feature. If it's possible,
I wonder if a developer could add this feature.

GOTO isn't possible - not with current plpgsql interpret.

workaround is simple, but ugly - add an cycle and CONTINUE or EXIT statements.

regards
Pavel Stehule

Show quoted text

Sure ! Here it is : http://tinyurl.com/anel

Thank you in advance, send me an email if you have an answer.

yw :)

--
F4FQM
Kerunix Flan
Laurent Laborde

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

#4Merlin Moncure
mmoncure@gmail.com
In reply to: Demise Garrouste (#1)
Re: Extend PL/pgSQL

On Tue, Apr 21, 2009 at 3:09 AM, Demise Garrouste <b.pijoulat@tele2.fr> wrote:

Hello,

I am in workplacement in a company and I have to make a migration from one
database to PostGreSQL. Nevertheless, the migration is not possible, because
I don't have the GOTO instruction. I know this is a bad practice, however, I
wanted to know if it's possible to implement this feature. If it's possible,
I wonder if a developer could add this feature. Thank you in advance, send
me an email if you have an answer.

maybe if you provided a scenario where you think goto is required you
could get some suggestions.

merlin