> pavel.steh...@gmail.com wrote:
>
>> b...@yugabyte.com wrote:
>>
>> As it happens, Oracle's PL/SQL has a "goto" statement. But PL/pgSQL does
>> not. (I assume that this is because "goto" is considered a bad thing.) But
>> PL/SQL programmers do use it. However, the doc section:
>
> The reason
Hi
> As it happens, Oracle's PL/SQL has a "goto" statement. But PL/pgSQL does
> not. (I assume that this is because "goto" is considered a bad thing.) But
> PL/SQL programmers do use it. However, the doc section:
>
The reason why PL/pgSQL has not "goto" statement is mainly technological.
PL/pgSQ
> x...@thebuild.com wrote:
>
>> b...@yugabyte.com wrote:
>>
>> What is the rationale for supporting what seems to be on its face this
>> strange functionality?
>
> It allows you to EXIT or CONTINUE a loop that is not the innermost one, by
> naming the label of an outer loop. One can debate end
On 7/10/23 12:08, DAVID ROTH wrote:
I am a newbe at my current job.
They have a separate log table for every table because they want all the
columns.
I have been looking for a way to go to a common log table without requiring
major changes to the application.
With your help, I have a proof of
I am a newbe at my current job.
They have a separate log table for every table because they want all the
columns.
I have been looking for a way to go to a common log table without requiring
major changes to the application.
With your help, I have a proof of principle that I can demonstrate now.
> On Jul 10, 2023, at 11:54, Bryn Llewellyn wrote:
>
> What is the rationale for supporting what seems to be on its face this
> strange functionality?
It allows you to EXIT or CONTINUE a loop that is not the innermost one, by
naming the label of an outer loop.
One can debate endlessly whet
I wanted to see what error(s) would be reported if "exit" or "continue" is
used, in PL/pgSQL, outside of a loop—and in particular if these were reported
as syntax errors or runtime errors. There were no surprises with "continue".
But I was surprised by this:
create procedure p()
language plpg
