Re: [HACKERS] [v9.2] make_greater_string() does not return a string in some cases

2011-09-21 Thread Tom Lane
Robert Haas writes: > I'm a bit perplexed as to why we can't find a non-stochastic way of doing > this. Because the behavior of common collation algorithms is so wacky as to approach stochasticity. In particular, as soon as your string contains a mix of letter and non-letter characters, "dictio

Re: [HACKERS] EXPLAIN and nfiltered, take two

2011-09-21 Thread Tom Lane
Here's a revised version of the patch that behaves in a way that seems reasonable to me, in particular it suppresses zero filter-count rows in text mode. I've not done anything yet about the documentation. regards, tom lane diff --git a/src/backend/commands/explain.c b/sr

Re: [HACKERS] Range Types - typo + NULL string constructor

2011-09-21 Thread Jeff Davis
On Thu, 2011-09-22 at 02:31 +0200, Florian Pflug wrote: > My personal favourite would be '0', since it resembles the symbol used > for empty sets in mathematics, and we already decided to use mathematical > notation for ranges. > > If we're concerned that most of our users won't get that, then 'em

Re: [HACKERS] EXPLAIN and nfiltered, take two

2011-09-21 Thread Heikki Linnakangas
On 22.09.2011 07:51, Tom Lane wrote: Here's a revised version of the patch that behaves in a way that seems reasonable to me, in particular it suppresses zero filter-count rows in text mode. I've not done anything yet about the documentation. I haven't been following this closely, so sorry if

Re: [HACKERS] EXPLAIN and nfiltered, take two

2011-09-21 Thread Tom Lane
Heikki Linnakangas writes: > I haven't been following this closely, so sorry if this has already been > discussed, but: > I find it a bit strange to print the number of lines filtered out. I > think that's the only place where we would print a "negative" like that, > everywhere else we print t

<    1   2