Skip site navigation (1) Skip section navigation (2)

Re: MetaData (size of datatype)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Shra <shravan(at)yaskatech(dot)com>
Cc: Hannu Krosing <hannu(at)krosing(dot)net>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: MetaData (size of datatype)
Date: 2002-04-29 14:39:34
Message-ID: 23624.1020091174@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-committerspgsql-hackers
Shra <shravan(at)yaskatech(dot)com> writes:
> As tom said.....The type is encoded in the atttypmod field (see PQfmod) and 
> recommendedusing format_type().....
> but when this is used, it returns -1 for integer , real n other fixed 
> datatypes .........

The interpretation of typmod is datatype-specific.  That's why I
recommended using format_type.  But if you want to know what format_type
knows, look at the source code (src/backend/utils/adt/format_type.c).

			regards, tom lane

In response to

pgsql-hackers by date

Next:From: Francois SuterDate: 2002-04-29 15:05:27
Subject: Re: pid gets overwritten in OSX
Previous:From: Tom LaneDate: 2002-04-29 14:28:41
Subject: Re: pid gets overwritten in OSX

pgsql-bugs by date

Next:From: Laurent BelmonteDate: 2002-04-29 16:39:28
Subject: timestamp in trigger
Previous:From: Hannu KrosingDate: 2002-04-29 13:54:01
Subject: Re: MetaData (size of datatype)

pgsql-committers by date

Next:From: Tom LaneDate: 2002-04-29 17:30:18
Subject: pgsql/src/bin/pg_dump pg_dump.c
Previous:From: Hannu KrosingDate: 2002-04-29 13:54:01
Subject: Re: MetaData (size of datatype)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group