Re: [GENERAL] Allow disabling folding of unquoted identifiers to lowercase

2016-05-03 Thread Evgeny Morozov
te: > On Mon, May 2, 2016 at 3:03 AM, Evgeny Morozov < > evgeny.morozov+list+pg...@shift-technology.com> wrote: > >> On 30 April 2016 at 01:31, Tom Lane wrote: >> >>> Yeah, this isn't going to happen. Years ago we looked into what it would >>> tak

Re: [GENERAL] Allow disabling folding of unquoted identifiers to lowercase

2016-05-02 Thread Evgeny Morozov
On 30 April 2016 at 01:31, Tom Lane wrote: > Yeah, this isn't going to happen. Years ago we looked into what it would > take to be able to flip a switch and have the standard-compliant behavior > (fold to upper not lower). It was impractical then and no doubt is far > more so now. I do not rem

[GENERAL] Allow disabling folding of unquoted identifiers to lowercase

2016-04-29 Thread Evgeny Morozov
It would be great if Postgres had a server setting that allowed the automatic folding of identifiers to lowercase to be disabled, so that camel case identifiers could be used without having to quote every single identifier, i.e. SELECT MyColumn FROM MyTable ORDER BY MyColumn instead of SELECT "M

Re: [GENERAL] substring on bit(n) and bytea types is slow

2016-03-02 Thread Evgeny Morozov
On 2 March 2016 at 00:33, Arjen Nienhuis wrote: > > On Feb 29, 2016 22:26, "Evgeny Morozov" < > evgeny.morozov+list+pg...@shift-technology.com> wrote > > SELECT substring(bitarray from (32 * (n - 1) + 1) for 32) -- bitarray is > a column of type bit(6400

Re: [GENERAL] substring on bit(n) and bytea types is slow

2016-03-02 Thread Evgeny Morozov
On 2 March 2016 at 00:33, Arjen Nienhuis wrote: > > On Feb 29, 2016 22:26, "Evgeny Morozov" < > evgeny.morozov+list+pg...@shift-technology.com> wrote > > SELECT substring(bitarray from (32 * (n - 1) + 1) for 32) -- bitarray is > a column of type bit(6400

[GENERAL] substring on bit(n) and bytea types is slow

2016-02-29 Thread Evgeny Morozov
ently. Regards, Evgeny Morozov