Re: Question about a query with two count fields - Mailing list pgsql-general

From Tom Lane
Subject Re: Question about a query with two count fields
Date
Msg-id 15682.1189535304@sss.pgh.pa.us
Whole thread Raw
In response to Re: Question about a query with two count fields  ("George Pavlov" <gpavlov@mynewplace.com>)
Responses Re: Question about a query with two count fields  (David Fetter <david@fetter.org>)
List pgsql-general
"George Pavlov" <gpavlov@mynewplace.com> writes:
>> From: David Fetter [mailto:david@fetter.org]
>> This case statement returns true when z factorial is zero, so I'd
>> recommend the SQL standard <> or IS NOT DISTINCT FROM instead.

> i do hate potential ambiguity... the != was something stuck in my brain
> from old sybase, i think. i always liked != ("not equals") as more
> intuitive than <> ("less than, greater than"???), but i will have to
> change my ways, especially if "the standard" says so.

The notion that != might be scanned as two operators whereas <> would
not be is nonsense.  I assume David was just joking.

            regards, tom lane

pgsql-general by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: Sthange things happen: SkyTools pgbouncer is NOT a balancer
Next
From: David Fetter
Date:
Subject: Re: Question about a query with two count fields