Postgres Pro
Downloads
Home   >   mailing lists

Re: Using a Conversion Table - Mailing list pgsql-general

From Greg Sabino Mullane
Subject Re: Using a Conversion Table
Date
Msg-id CAKAnmm++F0SiNBpRt9smmZXP39-gCPoW_5ZPP7xSR8OuSpKngQ@mail.gmail.com
Whole thread Raw
In response to Using a Conversion Table  (Anthony Apollis <anthony.apollis@gmail.com>)
Responses Re: Using a Conversion Table  ("Peter J. Holzer" <hjp-pgsql@hjp.at>)
List pgsql-general
Tree view
    "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:


Cheers,
Greg

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


pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Using a Conversion Table
Next
From: Tom Lane
Date:
Subject: Re: Two test failures on v16 (compared to v14)