Re: Substract queries

Поиск
Список
Период
Сортировка
От Robins Tharakan
Тема Re: Substract queries
Дата
Msg-id 36af4bed0805220827m1fb61247o62efcd48851f7d99@mail.gmail.com
обсуждение
Ответ на Substract queries  ("Nacef LABIDI" <nacef.l@gmail.com>)
Список pgsql-sql
Probably you are looking for EXCEPT.

SELECT * FROM Tbl1 WHERE a=1
EXCEPT
SELECT * FROM tbl2 WHERE a=1 and b=1;

http://www.postgresql.org/docs/8.3/interactive/sql-select.html

Regards,
Robins Tharakan

---------- Forwarded message ----------
From: Nacef LABIDI <nacef.l@gmail.com>
Date: Thu, May 22, 2008 at 8:45 PM
Subject: [SQL] Substract queries
To: pgsql-sql@postgresql.org


Hi all,

I was wondering how can I substract result between select queries. I mean I want to issue a query that does this :
(select * from mytable where condition1) - (select * from mytable where condition2)

Thanks to all

Nacef

В списке pgsql-sql по дате отправления: