How to know the type of an expression ? - Mailing list pgsql-general

From maa1666@yahoo.fr
Subject How to know the type of an expression ?
Date
Msg-id 1161949128.973066.108890@m7g2000cwm.googlegroups.com
Whole thread Raw
List pgsql-general
Is there a means to know the type of an expression ?
Something like a "typeof" function ?

As I work a lot with numbers of type "numeric", I often want to know
the precision of the result returned by an expression, in case the
returned result is "numeric".
I would also like to know if numbers of type "numeric" have not been
silently converted to "double precision" somewhere in the expression.

Best regards

Nicolas Riesch


pgsql-general by date:

Previous
From: lord.zoltar@gmail.com
Date:
Subject: arrays of user types.
Next
From: chelliah gabriel - Sun Microsystems - Bangalore India
Date:
Subject: Instead of Triggers