On Saturday, May 18, 2019, Peter J. Holzer <
hjp-pgsql@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.Ram@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.