Re: Show type in psql SELECT

On 25 February 2013 12:48, Craig Ringer <craig@2ndquadrant.com> wrote:
> However, the thing I want most couldn't be provided by this patch
> because it seems to be a deeper server limitation: the ability to get
> typmod data from calculation results like
>
>     NUMERIC(8,3) '11.131' + NUMERIC(8,3) '12.123'

But is the derived typmod always available?

No, it usually isn't. I doubt this patch can provide that information because the server doesn't keep track of derived typmods through a lot of internal operations. If it can I'll jump for joy.

I was just pointing out that you can already get something similar to this patch's effects with pg_typeof . It's a nice convenience not to have to wrap everything in pg_typeof, though, and this patch seems useful.

-- Craig Ringer                   http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services