On 7 January 2016 at 00:11, Tom Lane <t...@sss.pgh.pa.us> wrote: > A different approach is that I'm not real sure why we want a function > that returns a modified numeric value at all. To the extent I understood > Marko's original use case, it seems like what you'd invariably do with the > result is extract its scale(). Why not skip the middleman and define a > function named something like minscale() or leastscale(), which returns an > int that is the smallest scale that would not drop data? (If you actually > did want the modified numeric value, you could use round(x, minscale(x)) > to get it.) >
minscale() sounds good to me. Re-reading Marko's original use case, it sounds like that specific example would boil down to a check that minscale(x) <= 2, although that can be done today using trunc(x,2) = x. Still, it seems that minscale() would be a useful general purpose function to have. Regards, Dean -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
