On 8/14/2013 5:17 AM, Ivan Radovanovic wrote:
> apparently pg_catalog.format_type for some types return quoted name
> ("char" for example), also I can't find decimal in results (there is
> numeric, but I would like to have complete list of supported types, so
> decimal should be included too). In documentation it is said that
> typlen of -1 or -2 means that type is variable length, but I don't
> know how to find out if type can have additional precision?
DECIMAL is not a type per say, its an alias for NUMERIC.
--
john r pierce 37N 122W
somewhere on the middle of the left coast