On Saturday, May 18, 2019, Peter J. Holzer <hjp-pg...@hjp.at> wrote: > On 2019-05-16 08:48:51 -0700, David G. Johnston wrote: > > On Thu, May 16, 2019 at 8:31 AM Daulat Ram <daulat....@exponential.com> > wrote: > > > > > > url_hash | bigint | | not null | > > > > > > Change the type of url_hash; make it text instead of bigint. > > Or numeric(38, 0). I think it isn't coincidence that he tries to store > a 38-digit number in it. >
You don’t perform math on a hash thus its not a number no matter that it may contain only digits. David J.
