Re: SELECT Query
От | Lee Harr |
---|---|
Тема | Re: SELECT Query |
Дата | |
Msg-id | apurij$1tv1$1@news.hub.org обсуждение исходный текст |
Ответ на | SELECT Query (Scott Taylor <scott.taylor@4i-dotcom.com>) |
Список | pgsql-general |
In article <200211011158.23530.scott.taylor@4i-dotcom.com>, Scott Taylor wrote: > Below is the result of a query on my table. I want to only return those > transactions that have a chart_id=10074, and if trans_id 10088 is one of > those, I want to return all 3 rows with that trans_id. > SELECT * FROM acc_trans WHERE chart_id=10074 OR trans_id IN (SELECT trans_id FROM acc_trans WHERE chart_id=10074) ; I think that is what you want. If it is slow, look at using EXISTS instead of IN. > accs=# select * from acc_trans; > trans_id | chart_id | amount | transdate | source | cleared | > fx_transaction > ----------+----------+----------+------------+--------------+---------+---------------- > 10088 | 10004 | -2062.12 | 2002-03-01 | | f | f > 10088 | 10037 | 1755 | 2002-03-01 | | f | f > 10088 | 10074 | 307.12 | 2002-03-01 | | f | f > 10092 | 10004 | -528.75 | 2002-03-12 | | f | f > 10092 | 10037 | 450 | 2002-03-12 | | f | f > 10092 | 10074 | 78.75 | 2002-03-12 | | f | f > 10088 | 10004 | 2062.12 | 2002-03-07 | | f | f > 10088 | 10002 | -2062.12 | 2002-03-07 | | f | f > 10096 | 10016 | 1169.75 | 2002-03-12 | | f | f > 10096 | 10047 | -1169.75 | 2002-03-12 | | f | f > 10096 | 10002 | 1169.75 | 2002-03-11 | | f | f > 10096 | 10016 | -1169.75 | 2002-03-11 | | f | f > 10098 | 10016 | 283.91 | 2002-03-12 | | f | f > 10098 | 10044 | -283.91 | 2002-03-12 | | f | f > 10099 | 10016 | 137.6 | 2002-03-12 | | f | f > 10099 | 10045 | -137.6 | 2002-03-12 | | f | f > 10100 | 10016 | 163.74 | 2002-03-12 | | f | f > 10100 | 10046 | -163.74 | 2002-03-12 | | f | f > 10092 | 10004 | 528.75 | 2002-03-20 | | f | f > 10092 | 10002 | -528.75 | 2002-03-20 | | f | f > 10101 | 10004 | -528.75 | 2002-03-20 | | f | f > 10101 | 10037 | 450 | 2002-03-20 | | f | f > 10101 | 10074 | 78.75 | 2002-03-20 | | f | f > > Regards > > Scott > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster
В списке pgsql-general по дате отправления: