Re: Extend PL/pgSQL

<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>

On Tue, Apr 21, 2009 at 9:09 AM, Demise Garrouste <b(dot)pijoulat(at)tele2(dot)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

Hello

2009/4/21 Laurent Laborde <kerdezixe(at)gmail(dot)com>:
> On Tue, Apr 21, 2009 at 9:09 AM, Demise Garrouste <b(dot)pijoulat(at)tele2(dot)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

> 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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>

On Tue, Apr 21, 2009 at 3:09 AM, Demise Garrouste <b(dot)pijoulat(at)tele2(dot)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