Search Postgresql Archives

Re: Question about a query with two count fields

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



"George Pavlov" <gpavlov@xxxxxxxxxxxxxx> writes:
>> From: David Fetter [mailto:david@xxxxxxxxxx]
>> 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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux