Re: using xmin in a query? - Mailing list pgsql-general

On 07/28/2011 03:09 PM, Michael Nolan wrote:

On Thu, Jul 28, 2011 at 12:23 PM, Andy Colson <andy@squeakycode.net> 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.

What about select count(*) from tablename where xmin::text::integer != 2;

Regards

Rodrigo