Hello
Statement CONTINUE isn't in PL/SQL too, I know it, but Oracle PL/SQL
has statement GOTO. I don't need GOTO statement, but 'continue' can be
very usefull for me. I have to do some ugly trick now. With little change,
we can enhance stmt EXIT for behavior continue.
After some work I can
Pavel,
Statement CONTINUE isn't in PL/SQL too, I know it, but Oracle PL/SQL
has statement GOTO. I don't need GOTO statement, but 'continue' can be
very usefull for me. I have to do some ugly trick now. With little change,
we can enhance stmt EXIT for behavior continue.
Can you explain a
On Thu, Jun 16, 2005 at 09:40:16 -0700,
Josh Berkus josh@agliodbs.com wrote:
Pavel,
Statement CONTINUE isn't in PL/SQL too, I know it, but Oracle PL/SQL
has statement GOTO. I don't need GOTO statement, but 'continue' can be
very usefull for me. I have to do some ugly trick now. With
Pavel Stehule [EMAIL PROTECTED] writes:
BEGIN
CONTINUE WHEN i = 10;
RAISE NOTICE '---1---';
END;
I find that really ugly and confusing. If we add a CONTINUE it's only
sensible to allow it inside a loop --- otherwise it's just a nonstandard
spelling of EXIT.
Pavel Stehule wrote:
What do you think about it? It's broke PL/SQL compatibility, I know, but
via last discussion I have opinion so Oracle compatibility isn't main
objective PL/pgSQL. There is some less/bigger diferencess: SQLSTATE,
EXCEPTION from my last proposal, atd.
Well, yes,
As a near-daily PL/pgSQL developer, I similarly agree.
-Jonah
Andrew Dunstan wrote:
Pavel Stehule wrote:
What do you think about it? It's broke PL/SQL compatibility, I know,
but via last discussion I have opinion so Oracle compatibility isn't
main objective PL/pgSQL. There is some
On Thu, 16 Jun 2005, Josh Berkus wrote:
Pavel,
Statement CONTINUE isn't in PL/SQL too, I know it, but Oracle PL/SQL
has statement GOTO. I don't need GOTO statement, but 'continue' can be
very usefull for me. I have to do some ugly trick now. With little change,
we can enhance stmt
On Thu, 16 Jun 2005, Tom Lane wrote:
Pavel Stehule [EMAIL PROTECTED] writes:
BEGIN
CONTINUE WHEN i = 10;
RAISE NOTICE '---1---';
END;
I find that really ugly and confusing. If we add a CONTINUE it's only
sensible to allow it inside a loop --- otherwise it's just a
Well, yes, but I don't think we should break compatibility
arbitrarilly. I guess it could be argued that this is a missing feature
in PL/SQL and its Ada parent - implementing GOTO just to handle this
case seems unnecessary.
Yes. I din't use goto 5 years :-). Continue stmt is more