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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general