Search Postgresql Archives

Re: Order by with column ordinal and collate - fails to parse

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Nice one. Yep, that works. Cheers..
I'll submit a bug report for this, though I'm on the fence as to wether this is actually a bug per se.. I would have reasonably expected my original syntax to have worked (as it does without any ORDER BY)..   


On Thu, Jun 20, 2013 at 3:44 PM, Adrian Klaver <adrian.klaver@xxxxxxxxx> wrote:
On 06/20/2013 07:05 AM, Tim Kane wrote:
Hi all,

I seem to be having problems constructing a query that combines the use
of distinct, order by, and collate key words.

For instance:

# select distinct(value)  from properties order by 1 collate "C";
ERROR:  collations are not supported by type integer
LINE 1: ... distinct(value)  from properties order by 1 collate "C...
                                                              ^

How about:

select distinct(value) collate "C" from properties order by 1 ;



Am I just being a numpty here? I can work around it with a subquery, but
this seems like a bug to me. Particularly the first example where my
ordinal field reference is treated as an integer literal. I should note
that the field 'value' is of type 'text' (not integer).

Any input appreciated. Thanks :)



--
Adrian Klaver
adrian.klaver@xxxxxxxxx


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux