Postgres Pro
Downloads
Home   >   mailing lists

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

From Andy Colson
Subject Re: using xmin in a query?
Date
Msg-id 4E319B03.5060502@squeakycode.net
Whole thread Raw
In response to using xmin in a query?  (Michael Nolan <htfoot@gmail.com>)
Responses Re: using xmin in a query?  (Michael Nolan <htfoot@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Gavrina, Irina"
Date:
Subject: How to implement autostart of postgres?
Next
From: bubba postgres
Date:
Subject: pg_largeobject vs pg_toast_XXXX