On Wed, Jul 17, 2013 at 1:25 PM, Robert James <srobertjames@xxxxxxxxx> wrote: > Is there any way to set a variable or parameter for a query? > > I have a long query where a certain variable needs to be easy to > change. I'd like to do something like: > > threshold = 10.3 > > SELECT... WHERE x > $threshold... AND y * 1.3 > $threshold... > > Currently, I need to do this in a scripting language. Is there a > straightforward way to do this directly in Postgres? Using which client? psql? In this case there is that: http://www.postgresql.org/docs/devel/static/app-psql.html#APP-PSQL-INTERPOLATION postgres=# \set foo 1 postgres=# select :foo; ?column? ---------- 1 (1 row) mpaquier=# \set foo bar mpaquier=# select :'foo'; ?column? ---------- bar (1 row) Regards, -- Michael -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
