Levi Aul <levi(at)leviaul(dot)com> writes:
> It turns out it was actually the *client* I was originally using for
> testing my queries (Postico) that was losing precision! The query was fine!
I did think of that possibility, but rejected it because you indicated
you'd done some server-side tracing to confirm what you were seeing.
Oh well.
regards, tom lane