Sub Query
Started by Anand Sureliaover 27 years ago1 messagesgeneral
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.