Re: [HACKERS] Proposal - Continue stmt for PL/pgSQL

2005-06-16 Thread Pavel Stehule
> > 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

Re: [HACKERS] Proposal - Continue stmt for PL/pgSQL

2005-06-16 Thread Pavel Stehule
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

Re: [HACKERS] Proposal - Continue stmt for PL/pgSQL

2005-06-16 Thread Pavel Stehule
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 enhan

Re: [HACKERS] Proposal - Continue stmt for PL/pgSQL

2005-06-16 Thread Jonah H. Harris
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 less/

Re: [HACKERS] Proposal - Continue stmt for PL/pgSQL

2005-06-16 Thread Andrew Dunstan
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,

Re: [HACKERS] Proposal - Continue stmt for PL/pgSQL

2005-06-16 Thread Tom Lane
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.

Re: [HACKERS] Proposal - Continue stmt for PL/pgSQL

2005-06-16 Thread Bruno Wolff III
On Thu, Jun 16, 2005 at 09:40:16 -0700, 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 cha

Re: [HACKERS] Proposal - Continue stmt for PL/pgSQL

2005-06-16 Thread Josh Berkus
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

[HACKERS] Proposal - Continue stmt for PL/pgSQL

2005-06-16 Thread Pavel Stehule
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