Re: Need help how to reproduce MySQL binary to PosgreSQL

From: Geoff Winkless <pgsqladmin(at)geoff(dot)dj>
To: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Need help how to reproduce MySQL binary to PosgreSQL
Date: 2020-08-09 12:41:32
Message-ID: CAEzk6feuktNhiU-oNzQLOVs0BXxhuY8jrSpdNfm5QRtbsPYXHg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, 9 Aug 2020 at 12:49, Condor <condor(at)stz-bg(dot)com> wrote:
> Yea, I checked it, but because is 3 years old solution I expect these
> functions to be implemented long ago and just have another names or to
> have similar functions that do the same functionality. It's seems not,
> Okay will use the solution from sof.

Those functions _have_ been implemented long ago with other names, as
per the answer to the link given.

The functions you want are encode and decode, or to_hex if you want to
encode integers. The only reason to use the CREATE FUNCTION shims as
per the answer is if you don't want to change your code.

You might find https://pgxn.org/dist/mysqlcompat/ helpful too.

Geoff

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rama Krishnan 2020-08-10 03:01:20 Need a depth information about bloat
Previous Message Condor 2020-08-09 11:49:49 Re: Need help how to reproduce MySQL binary to PosgreSQL