| From: | Shra <shravan(at)yaskatech(dot)com> |
|---|---|
| To: | Hannu Krosing <hannu(at)krosing(dot)net> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: MetaData (size of datatype) |
| Date: | 2002-04-29 11:16:34 |
| Message-ID: | f0204291714560232@yaskatech.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-committers pgsql-hackers |
Hi Hannu,
> -1 is given for types that are of fixed size and whose length can be
> read from pg_type.typlen for that type.
I don't think so...jsut look into this file pq_type.h.... it says.........
*****************************************************************
typlen is the number of bytes we use to represent a value of this type, e.g.
4 for an int4. But for a variable length type, typlen is -1
*****************************************************************
-1 is for variable length n not for fixed length.........this point is very
clear even in documentation..........
now how to find length for a numeric, varchar or anyother one that has
variable length where the system PQfsize returns -1.........?
As tom said.....The type is encoded in the atttypmod field (see PQfmod) and
recommended using format_type().....
but when this is used, it returns -1 for integer , real n other fixed
datatypes .........
any better way , please.........
Shra
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hannu Krosing | 2002-04-29 13:54:01 | Re: MetaData (size of datatype) |
| Previous Message | Ram | 2002-04-29 06:31:56 | Problem |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hannu Krosing | 2002-04-29 13:54:01 | Re: MetaData (size of datatype) |
| Previous Message | Shra | 2002-04-29 06:20:25 | MetaData (size of datatype) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hannu Krosing | 2002-04-29 13:54:01 | Re: MetaData (size of datatype) |
| Previous Message | Francois Suter | 2002-04-29 08:46:49 | Re: pid gets overwritten in OSX |