Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Index usage when bitwise operator is used
- From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
- To: "valgog" <valgog(at)gmail(dot)com>,<pgsql-performance(at)postgresql(dot)org>
- Subject: Re: Index usage when bitwise operator is used
- Date: Mon, 17 Sep 2007 07:27:15 -0500
>>> On Mon, Sep 17, 2007 at 2:49 AM, in message <1190015368(dot)148293(dot)56830(at)y42g2000hsy(dot)googlegroups(dot)com>, valgog <valgog(at)gmail(dot)com> wrote: >> What about saying?: >> >> TBL1.CATEGORY = TBL2.CATEGORY >> > > Are you sure you understood what was the question? > > Is the TBL1.CATEGORY = TBL2.CATEGORY the same as TBL1.CATEGORY & > TBL2.CATEGORY > 0? Yes, given that he stipulated that one and only one bit would be set. -Kevin
- Follow-Ups:
- Re: Index usage when bitwise operator is used
- From: Tom Lane
- Re: Index usage when bitwise operator is used
- References:
- Index usage when bitwise operator is used
- From: W.Alphonse HAROUNY
- Re: Index usage when bitwise operator is used
- From: Kevin Grittner
- Re: Index usage when bitwise operator is used
- From: valgog
- Index usage when bitwise operator is used
- Prev by Date: Re: [Again] Postgres performance problem
- Next by Date: Re: [Again] Postgres performance problem
- Previous by thread: Re: Index usage when bitwise operator is used
- Next by thread: Re: Index usage when bitwise operator is used
- Indexes: