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