Postgres Pro
Downloads
Home   >   mailing lists

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

From Michael Nolan
Subject Re: using xmin in a query?
Date
Msg-id CAOzAquJ=GPZqiOk7Ba6pm5PqsBw_Yu4EJgeR53usfP6TM_e2+A@mail.gmail.com
Whole thread Raw
In response to Re: using xmin in a query?  (Andy Colson <andy@squeakycode.net>)
Responses Re: using xmin in a query?  (Rodrigo Gonzalez <rjgonzale@estrads.com.ar>)
List pgsql-general
Tree view


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


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

-Andy

pgsql-general by date:

Previous
From: bubba postgres
Date:
Subject: pg_largeobject vs pg_toast_XXXX
Next
From: Wells Oliver
Date:
Subject: I'm in the depths of a CAST nightmare and I can't work my out