Re: How to know the type of an expression ?

From: "Albe Laurenz" <all(at)adv(dot)magwien(dot)gv(dot)at>
To: <maa1666(at)yahoo(dot)fr>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to know the type of an expression ?
Date: 2006-10-30 09:02:47
Message-ID: 52EF20B2E3209443BC37736D00C3C1380B2D9B63@EXADV1.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Which API are you using?

Yours,
Laurenz Albe

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Staubo 2006-10-30 09:27:45 Re: postgresql books and convertion utilities
Previous Message Peter Wilson 2006-10-30 08:54:04 Re: Replicating changes