Re: using xmin in a query?

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 <>.

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

-Andy