Postgres SELECT values where only some columns respect WHERE clause

Question

I have a table that I wish to select from. I want to select the same column twice, once with some date based filtering in the WHERE clause, and again without the filtering. How can I go about doing this?

Thanks

With 1000 rep I'm surprised you haven't written a better question. Table definitions/sample data, PostgreSQL version, desired results, etc. — Craig Ringer
– Craig Ringer, Commented May 16, 2013 at 2:10

Craig Ringer · Accepted Answer · 2013-05-16 02:10:07Z

2

Use a UNION query, possibly with a CTE.

You haven't provided table definitions so I can't provide real SQL. You're looking for something like this:

SELECT *
FROM thetable
WHERE ...datefilter ...
UNION ALL
SELECT *
FROM thetable
WHERE ... otherfilter...;

You may find common table expressions ("WITH" queries) useful too.

answered May 16, 2013 at 2:10

Craig Ringer

329k84 gold badges743 silver badges821 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgres SELECT values where only some columns respect WHERE clause

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related