[Solved] You created a view with:CREATE VIEW recent_sales AS SELECT * FROM sales WHERE sale_date > CURRENT_DATE - INTERVAL '7 days';But running SELECT * FROM recent_sales; returns an error.... | PostgreSQL

PostgreSQL - Views and Materialized Views

You created a view with:

CREATE VIEW recent_sales AS SELECT * FROM sales WHERE sale_date > CURRENT_DATE - INTERVAL '7 days';

But running SELECT * FROM recent_sales; returns an error. What is the likely cause?

ACURRENT_DATE cannot be used in a view definition

BThe view definition is correct; error is elsewhere

CThe view needs to be refreshed manually to update data

DThe INTERVAL syntax is invalid in the view definition

Step-by-Step Solution

Solution:

Step 1: Check if INTERVAL and CURRENT_DATE are valid
Both INTERVAL and CURRENT_DATE are valid in PostgreSQL and can be used in views.
Step 2: Understand view behavior
Views are virtual and always reflect current data; no manual refresh needed.
Final Answer:
The view definition is correct; error is elsewhere -> Option B
Quick Check:
Valid syntax means error is not in view code = A [OK]

Quick Trick: Check error source; valid syntax means problem is outside view [OK]

Common Mistakes:

Master "Views and Materialized Views" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

You created a view with: