using WITH clause for PostgreSQL?

Question

I was planning to use the WITH clause with PostgreSQL, but it doesn't seem to support the command. Is there a substitute command?

What I want to do is with one query select several sub-resultsets and use parts of the sub-resultsets to create my final SELECT.

That would have been easy using the WITH clause.

UPDATE:

Opps! I discovered that I misunderstood the error message I got; and pgSQL does support WITH.

Check the manual: postgresql.org/docs/current/interactive/queries-with.html — Frank Heikens
– Frank Heikens, Commented Dec 14, 2012 at 11:53

Craig Ringer · Accepted Answer · 2012-12-14 13:18:20Z

1

PostgreSQL supports common-table expressions (WITH queries) in version 8.4 and above. See common table expressions in the manual.

You should really include your PostgreSQL version, the exact text of the error message, and the exact text of any query you ran in your question. Where practical/relevant also include table definitions, sample data, and expected results.

answered Dec 14, 2012 at 13:18

Craig Ringer

329k83 gold badges742 silver badges820 bronze badges

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

Collectives™ on Stack Overflow

using WITH clause for PostgreSQL?

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