"Marc G. Fournier" <[EMAIL PROTECTED]> writes:
> On Mon, 11 Oct 2004, Tom Lane wrote:
>> "numeric", hm? Is the referenced column also of type numeric?
> Correct, and a join of the two tables appears to use both indices, altho
> one is of numeric(9,0) and the other numeric(12,0) ... could that
> difference post a problem from a FK perspective that a SELECT/JOIN
> wouldn't show?
No. I wonder though how big a speed boost you'd get from converting
these columns (and all the ones linked to them) to BIGINT ...
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
