Thu, 17 Jan 2013 05:56:02 -0800 (PST)
Jan 2013 05:56:02 -0800 (PST)
X-Newsgroups: pgsql.interfaces.pgadmin.support
Date: Thu, 17 Jan 2013 05:56:02 -0800 (PST)
Complaints-To: groups-abuse(at)google(dot)com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=79.121.57.171;
posting-account=Qgz6DQoAAABy7twg8l6on0iP0KA6BAvN
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <2cf797a2-b773-495b-b310-5f27b1a34412(at)googlegroups(dot)com>
Subject: Live Result or filtering rows by another table?
From: durumdara(at)gmail(dot)com
Injection-Date: Thu, 17 Jan 2013 13:56:02 +0000
Content-Type: text/plain; charset=ISO-8859-1
To: pgadmin-support(at)postgresql(dot)org

Dear Support!

Will you plan to support "live results" in pgAdmin's future versions?

To avoid misunderstand:
Live or sensitive queries can edited.
If the query doesn't contains any joins, or fields from other tables, the queries can be live/sensitive, and the result is editable.

It is very useful thing when we want to edit just specific rows without opening two subwindows, and copy the row ids one by one.

For example:
select * from details where master_id is in (select id from master where long condition)

Or can I use subqueries in the filter of the data edit window?

Thanks for your help: dd