| From: | Rodrigo Gonzalez <rjgonzale(at)estrads(dot)com(dot)ar> |
|---|---|
| To: | Michael Nolan <htfoot(at)gmail(dot)com> |
| Cc: | Andy Colson <andy(at)squeakycode(dot)net>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: using xmin in a query? |
| Date: | 2011-07-28 18:46:40 |
| Message-ID: | 4E31AE90.3040605@estrads.com.ar |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 07/28/2011 03:09 PM, Michael Nolan wrote:
>
>
> On Thu, Jul 28, 2011 at 12:23 PM, Andy Colson <andy(at)squeakycode(dot)net
> <mailto:andy(at)squeakycode(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2011-07-28 19:26:44 | Re: How to implement autostart of postgres? |
| Previous Message | Wells Oliver | 2011-07-28 18:22:44 | I'm in the depths of a CAST nightmare and I can't work my out |