Thread: Sub Query

Sub Query

From
Anand
Date:
Hi,
I am getting a PQExec error (backend closed channel) when I run this query.

delete from session where age('now',lastused) > '30 minutes'::timespan and
    sessionid in (select session.sessionid from session,administration
              where session.sessionid=administration.sessionid)

Doesn't Postgres support sub queries in delete statement?

- Anand.