select translate(string,'০১২৩৪৫৬৭৮৯','0123456789');
seems to do the trick.
On Mon, 25 Nov 2019 at 16:38, Bob Jolliffe wrote:
>
> Thanks Tom. That is what I expected to hear. Was being hopeful ...
>
> On Mon, 25 Nov 2019 at 16:27, Tom Lane wrote:
> >
> > Bob Jolliffe writes:
> > > I have an
Thanks Tom. That is what I expected to hear. Was being hopeful ...
On Mon, 25 Nov 2019 at 16:27, Tom Lane wrote:
>
> Bob Jolliffe writes:
> > I have an interesting problem. I have a string field in a table which
> > (sometimes) is expected to contain numeric values ie. a cast of the
> > fiel
Bob Jolliffe writes:
> I have an interesting problem. I have a string field in a table which
> (sometimes) is expected to contain numeric values ie. a cast of the
> field to INTEGER is supposed to succeed.
> My issue is that the application is running in Bangladesh, and
> sometimes the users ha
