Return to Answer

###Option 1: Let Postgres calculate and set new variables with \gset

The manual about \gset:

###Option 2: Function with dynamic SQL for repeated use

You could use a DO statement, but (the manual again):

• How to create temporary function in Postgres

We need dynamic SQL with EXECUTE. The manual about Variable Substitution:

• Error when setting n_distinct using a plpgsql variable

Option 1: Let Postgres calculate and set new variables with \gset

The manual about \gset:

Option 2: Function with dynamic SQL for repeated use

You could use a DO statement, but (the manual again):

• How to create temporary function in Postgres

We need dynamic SQL with EXECUTE. The manual about Variable Substitution:

• Error when setting n_distinct using a plpgsql variable

We need dynamic SQL wit EXECUTE. The manual about Variable Substitution:

We need dynamic SQL with EXECUTE. The manual about Variable Substitution:

• How to create temporary function in Postgres

• Error when setting n_distinct using a plpgsql variable

• How to create temporary function in Postgres

• Error when setting n_distinct using a plpgsql variable