Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id B23F2475872 for ; Sat, 17 Aug 2002 01:29:50 -0400 (EDT) Received: from mail-relay.trade-india.com (mail-relay.trade-india.com [203.196.129.235]) by postgresql.org (Postfix) with SMTP id 148FB475469 for ; Sat, 17 Aug 2002 01:29:44 -0400 (EDT) Received: (qmail 14290 invoked from network); 17 Aug 2002 05:20:12 -0000 Received: from system67.trade-india-local.com (192.168.0.67) by infocom-236-129-del.trade-india.com with SMTP; 17 Aug 2002 05:20:12 -0000 Content-Type: text/plain; charset="us-ascii" From: "Rajesh Kumar Mallah." Organization: Infocom Network Limited. To: pgsql-sql@postgresql.org Subject: Difference between is true and = 't' in boolean feild. & bitmap indexes Date: Sat, 17 Aug 2002 11:02:58 +0530 User-Agent: KMail/1.4.1 MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200208171102.58808.mallah@trade-india.com> X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/253 X-Sequence-Number: 9099 Any can anyone explain me why in a query of a boolean feild "is ture" does= not indexes where as =3D 't' does? is "is true" not a more standard SQL than " =3D 't' ". Also is there any working implementation of BITMAP INDEXES in postgresql as= found in ORACLE?=20 regds mallah. tradein_clients=3D> explain analyze select c.email,date(a.generated),c.expi= red from eyp_rfi a join users b on (a.receiver_uid =3D b.userid)=20 join grace_mytradeindia c on (b.email =3D c.email) where generated_date =3D= '2002-08-17' and c.expired is true; NOTICE: QUERY PLAN: Hash Join (cost=3D1948.01..2214.60 rows=3D14 width=3D67) (actual time=3D9.= 32..40.03 rows=3D12 loops=3D1) -> Seq Scan on grace_mytradeindia c (cost=3D0.00..246.17 rows=3D4051 wi= dth=3D26) (actual time=3D0.65..27.76 rows=3D5372 loops=3D1) -> Hash (cost=3D1947.46..1947.46 rows=3D218 width=3D41) (actual time=3D= 2.66..2.66 rows=3D0 loops=3D1) -> Nested Loop (cost=3D0.00..1947.46 rows=3D218 width=3D41) (actu= al time=3D0.16..2.57 rows=3D31 loops=3D1) -> Index Scan using eyp_rfi_date on eyp_rfi a (cost=3D0.00.= .677.81 rows=3D218 width=3D12) (actual time=3D0.09..0.57 rows=3D50 loops=3D= 1) -> Index Scan using users_pkey on users b (cost=3D0.00..5.8= 0 rows=3D1 width=3D29) (actual time=3D0.03..0.03 rows=3D1 loops=3D50) Total runtime: 40.26 msec EXPLAIN tradein_clients=3D> explain analyze select c.email,date(a.generated),c.expi= red from eyp_rfi a join users b on (a.receiver_uid =3D b.userid)=20 join grace_mytradeindia c on (b.email =3D c.email) where generated_date =3D= '2002-08-17' and c.expired =3D 't'; NOTICE: QUERY PLAN: Hash Join (cost=3D1948.01..2144.70 rows=3D14 width=3D67) (actual time=3D6.= 26..49.92 rows=3D12 loops=3D1) -> Index Scan using grace_mytradeindia_exp on grace_mytradeindia c (cos= t=3D0.00..176.27 rows=3D4051 width=3D26) (actual time=3D0.03..37.53 rows=3D= 5372 loops=3D1) -> Hash (cost=3D1947.46..1947.46 rows=3D218 width=3D41) (actual time=3D= 2.15..2.15 rows=3D0 loops=3D1) -> Nested Loop (cost=3D0.00..1947.46 rows=3D218 width=3D41) (actu= al time=3D0.15..2.06 rows=3D31 loops=3D1) -> Index Scan using eyp_rfi_date on eyp_rfi a (cost=3D0.00.= .677.81 rows=3D218 width=3D12) (actual time=3D0.09..0.48 rows=3D50 loops=3D= 1) -> Index Scan using users_pkey on users b (cost=3D0.00..5.8= 0 rows=3D1 width=3D29) (actual time=3D0.02..0.03 rows=3D1 loops=3D50) Total runtime: 50.16 msec EXPLAIN tradein_clients=3D> --=20 Rajesh Kumar Mallah, Project Manager (Development) Infocom Network Limited, New Delhi phone: +91(11)6152172 (221) (L) ,9811255597 (M) Visit http://www.trade-india.com , India's Leading B2B eMarketplace.