Re: [GENERAL] using xmin in a query?

[Rodrigo Gonzalez]

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

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