AW: AW: [HACKERS] Re: atttypmod of 0 - Mailing list pgsql-hackers

From Zeugswetter Andreas DBT
Subject AW: AW: [HACKERS] Re: atttypmod of 0
Date
Msg-id 219F68D65015D011A8E000006F8590C6010A51C1@sdexcsrv1.sd.spardat.at
Whole thread Raw
Responses Re: AW: AW: [HACKERS] Re: atttypmod of 0  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-hackers
I guess I don't have a strong opinion on that. Since atttypmod is also
intended for
decimal and others, I think the default has to be type specific anyway,
like 0 digits after the comma for decimal.
I would prefer an atttypmod that does not include the VARHDRSZ for
varchar though.
Then it would simply be the max length (better for humans reading the
system catalog).
The default of zero would still be no problem I guess, since max zero
length is still nonsense.

Andreas

> > Yes, I think to change atttypmod to default to -1 would be the right
> > thing,
> > since the empty string '' really has a length of 0,
> > We could think of -1 as: We don't know how long this field will be.
> > 0 would mean the field has 0 bytes.
>
> Field has varlena == 4, so zero is not possible, but I could still
> change to -1 for clarity.
>

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: AW: [HACKERS] Re: atttypmod of 0
Next
From: Tom I Helbekkmo
Date:
Subject: Re: [HACKERS] Bug?