Обсуждение: Sub Query

Поиск
Список
Период
Сортировка

Sub Query

От
Anand
Дата:
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.