Question about format_type function

From: Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Question about format_type function
Date: 2005-04-04 00:57:53
Message-ID: 42509111.1030105@amsoftwaredesign.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

The format_type function is great, except for the way it formats varchars,
it always returns Character Varying or whatever, it would be nice if it
had a option to return a short version of
these names. i.e.

format_type(a.atttypid, a.atttypmod,true) would return all short names

format_type(a.atttypid, a.atttypmod,false) would return full names

I don't know of any other system that shows varchars in this way, they
should just be formated as varchar(50).

If there is another way to do this without messy case statements please
let me know.

Thanks,

Tony

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-04-04 01:02:18 Re: Strange plpgsql performance, diff plperl and plpgsql
Previous Message Tom Lane 2005-04-04 00:54:12 Re: Empty date