Vick, you are right. That’s why I’d wish to add some custom code to MY PostgreSQL instance and set such a sort order,
whichis optimal for my application.
On Jul 27, 2016, at 17:44, Vick Khera <vivek@khera.org> wrote:
> On Wed, Jul 27, 2016 at 3:28 AM, Anton Ananich <anton.ananich@gmail.com> wrote:
>> In my situation this order is invalid. Obviously, year 2016 should go after
>> 2014, like that:
>
> I think you expect JSONB to sort differently than it does. I cannot
> imagine what a "natural" ordering of arbitrary JSON objects is.
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general