Reference alias in WHERE clause

by

This is not possible as in sql, the order of execution is first, the where clause and then the select. At the time where clause is getting executed, it does not know what you have defined as an alias and so you will get that error.

You need to rewrite your query like this..

SELECT
    SUBSTRING(pk, 6, 2)::INT AS _year
FROM
    listing
WHERE
SUBSTRING(pk, 6, 2)::INT > 90

More Related Contents:

  1. Select rows which are not present in other table
  2. Optimize GROUP BY query to retrieve latest row per user
  3. How to implement a many-to-many relationship in PostgreSQL?
  4. Check if value exists in Postgres array
  5. How to use ANY instead of IN in a WHERE clause?
  6. Is there a shortcut for SELECT * FROM?
  7. sql statement error: “column .. does not exist”
  8. What is the difference between single quotes and double quotes in PostgreSQL?
  9. Constraint defined DEFERRABLE INITIALLY IMMEDIATE is still DEFERRED?
  10. Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
  11. Best way to count rows by arbitrary time intervals
  12. PostgreSQL sequence based on another column
  13. Sorting null values after all others, except special
  14. Finding similar strings with PostgreSQL quickly
  15. Fastest check if row exists in PostgreSQL
  16. Why do NULL values come first when ordering DESC in a PostgreSQL query?
  17. Slow simple update query on PostgreSQL database with 3 million rows
  18. Discard millisecond part from timestamp
  19. Return setof record (virtual table) from function
  20. How do I cast a string to integer and have 0 in case of error in the cast with PostgreSQL?
  21. SQL column reference “id” is ambiguous
  22. How to use multiple CTEs in a single SQL query?
  23. IN Clause with NULL or IS NULL
  24. postgres – where in (list) – column does not exist
  25. incomplete information from query on pg_views [duplicate]
  26. PostgreSQL: Give all permissions to a user on a PostgreSQL database
  27. Referencing current row in FILTER clause of window function
  28. Postgresql query between date ranges
  29. How to use SQL LIKE condition with multiple values in PostgreSQL?
  30. Is there a postgres CLOSEST operator?

Leave a Comment