How to declare a variable in a PostgreSQL query

by

I accomplished the same goal by using a WITH clause, it’s nowhere near as elegant but can do the same thing. Though for this example it’s really overkill. I also don’t particularly recommend this.

WITH myconstants (var1, var2) as (
   values (5, 'foo')
)
SELECT *
FROM somewhere, myconstants
WHERE something = var1
   OR something_else = var2;

More Related Contents:

  1. Refactor a PL/pgSQL function to return the output of various SELECT queries
  2. Dynamic alternative to pivot with CASE and GROUP BY
  3. Create unique constraint with null columns
  4. How do you use script variables in psql?
  5. Optimise PostgreSQL for fast testing
  6. Fast way to discover the row count of a table in PostgreSQL
  7. Best way to check for “empty or null value”
  8. How to avoid multiple function evals with the (func()).* syntax in a query?
  9. Time zone storage in data type “timestamp with time zone”
  10. Is there something like a zip() function in PostgreSQL that combines two arrays?
  11. Serial numbers per group of rows for compound key
  12. PostgreSQL parameterized Order By / Limit in table function
  13. Postgres analogue to CROSS APPLY in SQL Server
  14. Get the default values of table columns in Postgres?
  15. Division of integers returns 0
  16. PostgreSQL: how to convert from Unix epoch to date?
  17. Postgres not using index when index scan is much better option
  18. SQL update fields of one table from fields of another one
  19. Postgres – Function to return the intersection of 2 ARRAYs?
  20. How to store array or multiple values in one column
  21. convert Postgres geometry format to WKT
  22. Which datatype should be used for currency?
  23. How to return two columns with function
  24. COPY with dynamic file name
  25. Count cumulative total in Postgresql
  26. Prepared Statement on Postgresql in Rails
  27. SELECT DISTINCT is slower than expected on my table in PostgreSQL
  28. Temporal database design, with a twist (live vs draft rows)
  29. How to bulk insert only new rows in PostreSQL
  30. PostgreSQL – dynamic value as table name [duplicate]

Leave a Comment