Re: findTargetlistEntrySQL92() and COLLATE clause

2019-05-07 Thread Amit Langote
On 2019/04/27 0:02, Tom Lane wrote: > Amit Langote writes: >> I couldn't find old discussions or source code comments about this, but >> has someone encountered the following error and wondered whether it's >> working that way for a reason? > >> select a::text, b from foo order by 1, 2 collate "C

Re: findTargetlistEntrySQL92() and COLLATE clause

2019-04-26 Thread Tom Lane
Amit Langote writes: > I couldn't find old discussions or source code comments about this, but > has someone encountered the following error and wondered whether it's > working that way for a reason? > select a::text, b from foo order by 1, 2 collate "C"; > ERROR: collations are not supported by

findTargetlistEntrySQL92() and COLLATE clause

2019-04-25 Thread Amit Langote
Hi, I couldn't find old discussions or source code comments about this, but has someone encountered the following error and wondered whether it's working that way for a reason? select a::text, b from foo order by 1, 2 collate "C"; ERROR: collations are not supported by type integer LINE 1: selec