Re: numeric data type? - Mailing list pgsql-general

From John D. Burger
Subject Re: numeric data type?
Date
Msg-id aa8a61690937e5d00c709dcd10e9c633@mitre.org
Whole thread Raw
In response to Re: numeric data type?  (Doug McNaught <doug@mcnaught.org>)
Responses Re: numeric data type?  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
I have a (only vaguely) related question about NUMERICs.  I'm using
someone else's schema to copy data from their DB into mine.  They use
NUMERIC quite a bit, with scale 0, where I would use one of the integer
types.  My question is whether joining and matching on NUMERIC is
likely to be slower than, say, INTEGER.  Note that I'm never doing math
with these values, they are just IDs.

Thanks for any info provided!

- John D. Burger
   MITRE


pgsql-general by date:

Previous
From: Zlatko Matić
Date:
Subject: Re: numeric data type?
Next
From: Martijn van Oosterhout
Date:
Subject: Re: numeric data type?