Re: using xmin in a query?

[Michael Nolan <htfoot@xxxxxxxxx>]

On Thu, Jul 28, 2011 at 12:23 PM, Andy Colson <andy@xxxxxxxxxxxxxxx> wrote:

On 7/28/2011 11:40 AM, Michael Nolan wrote:

Why does this query succeed:

select count(*) from tablename where xmin = 2

while this query fails:

select count(*) from tablename where xmin != 2

You probably want <>.

That doesn't work either.
--
Mike Nolan

select count(*) from tablename where xmin <> 2

-Andy