Sub Query - Mailing list pgsql-general

From Anand
Subject Sub Query
Date
Msg-id 199810060054.RAA19940@inspire.bytekinc.com
Whole thread Raw
List pgsql-general
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.

pgsql-general by date:

Previous
From: Anand
Date:
Subject: ...
Next
From: Marc Eggenberger
Date:
Subject: How to have a autoincrement field?