AW: AW: [HACKERS] Re: atttypmod of 0

From: Zeugswetter Andreas DBT <Andreas(dot)Zeugswetter(at)telecom(dot)at>
To: "'Bruce Momjian'" <maillist(at)candle(dot)pha(dot)pa(dot)us>
Cc: "'pgsql-hackers(at)hub(dot)org'" <pgsql-hackers(at)hub(dot)org>
Subject: AW: AW: [HACKERS] Re: atttypmod of 0
Date: 1998-02-06 17:14:49
Message-ID: 219F68D65015D011A8E000006F8590C6010A51C1@sdexcsrv1.sd.spardat.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.
>

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1998-02-06 17:46:05 Re: [HACKERS] Profile of current backend
Previous Message Bruce Momjian 1998-02-06 17:09:38 Re: [HACKERS] Profile of current backend