Re: PL/pgSQL PERFORM WITH query

2022-02-10 Thread Erwin Brandstetter
On Tue, 8 Feb 2022 at 23:54, David G. Johnston wrote: > On Tue, Feb 8, 2022 at 3:14 PM Erwin Brandstetter > wrote: > >> The manual currently reads: >> >> https://www.postgresql.org/docs/current/plpgsql-statements.html#PLPGSQL-STATEMENTS-GENERAL-SQL >> >> > PERFORM query; >> >> > This executes qu

Re: PL/pgSQL PERFORM WITH query

2022-02-08 Thread David G. Johnston
On Tue, Feb 8, 2022 at 3:14 PM Erwin Brandstetter wrote: > The manual currently reads: > > https://www.postgresql.org/docs/current/plpgsql-statements.html#PLPGSQL-STATEMENTS-GENERAL-SQL > > > PERFORM query; > > > This executes query and discards the result. Write the query the same > way you woul

PL/pgSQL PERFORM WITH query

2022-02-08 Thread Erwin Brandstetter
The manual currently reads: https://www.postgresql.org/docs/current/plpgsql-statements.html#PLPGSQL-STATEMENTS-GENERAL-SQL > PERFORM query; > This executes query and discards the result. Write the query the same way you would write an SQL SELECT command, but replace the initial keyword SELECT wit