lt;> 1 would result true
- WHERE sort_order <> 1 would result true for records 2,3,4,5, returning
some_column anyway, which is not what you want
This can be done with an aggregate, a sub-select, or a JOIN -- there's
no way to do this using only a single-
ping by
some_column, include only groups where the number of grouped records
having sort_order=1 is zero."
--Will Glynn
Freedom Healthcare
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
e application can split it apart again, but that's really ugly.
--Will Glynn
Freedom Healthcare
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
#x27;s something in the PostgreSQL code,
but this server definitely didn't do this in the months under 7.4.
Mike: is your system AMD64, by any chance? The above system is, as is
another similar story I heard.
--Will Glynn
Freedom Healthcare
---(end of broadcast)-
tainly not enough to make the kernel kill
-9 postmaster. Kernel is 2.6.11-gentoo-r6, same as before the upgrade.
Also, this didn't happen in our test environment, which uses a similar
but x86 server. Perhaps this is AMD64 related?
--Will Glynn
Freedom Healthcare
---(
