Re: Using a Conversion Table

From: Greg Sabino Mullane <htamfids(at)gmail(dot)com>
To: Anthony Apollis <anthony(dot)apollis(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Using a Conversion Table
Date: 2024-02-14 15:02:37
Message-ID: CAKAnmm++F0SiNBpRt9smmZXP39-gCPoW_5ZPP7xSR8OuSpKngQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>
> "Fiscal year" double precision,
>

This column is an INTEGER in your other table, so your schema is not even
internally consistent! Try to use TEXT, INT, DATE and TIMESTAMPTZ whenever
possible, with NUMERIC as needed for things with a precision. See:

https://www.postgresql.org/docs/current/datatype-numeric.html

Cheers,
Greg

P.S. +1 for use of an identity column, though.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2024-02-14 15:09:26 Re: Two test failures on v16 (compared to v14)
Previous Message David G. Johnston 2024-02-14 14:31:56 Re: Using a Conversion Table