Sub Query

From: Anand <anand(at)bytekinc(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Sub Query
Date: 1998-10-06 00:54:29
Message-ID: 199810060054.RAA19940@inspire.bytekinc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 1998-10-06 02:23:13 Re: [HACKERS] RE: [GENERAL] Long update query ? (also Re: [GENERAL] CNF vs. DNF)
Previous Message Anand 1998-10-06 00:47:22