From: Anthony Ananich <anton.ananich@gmail.com>
Content-Type: multipart/alternative;
 boundary="Apple-Mail=_AAA2394D-ADDD-4BA1-8AAF-E73AB7777201"
Subject: Override sort order
Message-Id: <B4D3400F-AFCC-42B8-A655-333DB2473111@gmail.com>
Date: Tue, 28 Jun 2016 14:31:02 +0300
To: pgsql-docs@postgresql.org
Mime-Version: 1.0 (Mac OS X Mail 7.3 \(1878.6\))
Precedence: bulk
Sender: pgsql-docs-owner@postgresql.org


--Apple-Mail=_AAA2394D-ADDD-4BA1-8AAF-E73AB7777201
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=windows-1252

Dear All,

I=92ve got a need to change sort order for jsonb field. I=92m looking =
for a way to change =93order by=94 behavior like it is described in my =
previous question.

I=92ve found a piece of doc which says that it is possible to override =
method =93int compare(Datum a, Datum b)=94 here:
https://www.postgresql.org/docs/9.5/static/gin-extensibility.html

I wonder if there are any examples available?=20

If not I=92m opened to offer my help in making one.

Regards,
Anthony Ananich
http://ananich.pro=

--Apple-Mail=_AAA2394D-ADDD-4BA1-8AAF-E73AB7777201
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html;
	charset=windows-1252

<html><head><meta http-equiv=3D"Content-Type" content=3D"text/html =
charset=3Dwindows-1252"></head><body style=3D"word-wrap: break-word; =
-webkit-nbsp-mode: space; -webkit-line-break: =
after-white-space;"><div>Dear All,</div><div><br></div><div>I=92ve got a =
need to change sort order for jsonb field. I=92m looking for a way to =
change =93order by=94 behavior like it is described in&nbsp;<a =
href=3D"https://www.postgresql.org/message-id/1BFCD444-70DD-4A32-B2AB-CEFC=
C2922419@gmail.com">my previous =
question</a>.</div><div><br></div><div>I=92ve found a piece of doc which =
says that it is possible to override method =93int compare(Datum a, =
Datum
      b)=94 here:</div><a =
href=3D"https://www.postgresql.org/docs/9.5/static/gin-extensibility.html"=
>https://www.postgresql.org/docs/9.5/static/gin-extensibility.html</a><div=
><br></div><div>I wonder if there are any examples =
available?&nbsp;</div><div><br></div><div>If not I=92m opened to offer =
my help in making =
one.</div><div><br></div><div>Regards,</div><div>Anthony =
Ananich</div><div>http://ananich.pro</div></body></html>=

--Apple-Mail=_AAA2394D-ADDD-4BA1-8AAF-E73AB7777201--