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

From: Marcin Mańk <marcin(dot)mank(at)gmail(dot)com>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)oss(dot)ntt(dot)co(dot)jp>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [v9.2] make_greater_string() does not return a string in some cases
Date: 2011-09-23 17:35:48
Message-ID: 624360DC-C26A-4FA6-8C6A-26D28EA79422@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

One idea:
col like 'foo%' could be translated to col >= 'foo' and col <= foo || 'zzz' , where 'z' is the largest possible character. This should be good enough for calculating stats.

How to find such a character, i do not know.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Nicolas Beuzeboc 2011-09-23 18:49:09 BUG #6220: Flagstaff
Previous Message YAMAMOTO Takashi 2011-09-23 17:10:26 Re: BUG #6218: TRAP: FailedAssertion( "!(owner->nsnapshots == 0)", File: "resowner.c", Line: 365)

Browse pgsql-hackers by date

  From Date Subject
Next Message Merlin Moncure 2011-09-23 18:17:55 Re: "stored procedures"
Previous Message Robert Haas 2011-09-23 17:17:39 Re: unite recovery.conf and postgresql.conf