Recheck condition

From: "Josh Harrison" <joshques(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Recheck condition
Date: 2007-11-28 18:18:56
Message-ID: 8d89ea1d0711281018q26392162j85e9038192a32747@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
Sorry if my question is silly.
When I use explain analyze command I come across 'recheck condition' in some
places.
I googled for this but didn't get any solid answers.

What is recheck condition and when does the query planner choose this?
Thanks
josh

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2007-11-28 18:22:52 Re: Select all fields except one
Previous Message David Fetter 2007-11-28 18:14:52 Re: Select all fields except one