Re: int1? types? - Mailing list pgsql-general

From elein
Subject Re: int1? types?
Date
Msg-id 20031010165355.D6483@cookie.varlena.com
Whole thread Raw
In response to Re: int1? types?  (CSN <cool_screen_name90001@yahoo.com>)
Responses Re: int1? types?  (Joe Conway <mail@joeconway.com>)
Re: int1? types?  (Manfred Koizar <mkoi-pg@aon.at>)
List pgsql-general
I don't think that you can create a genuine one byte datatype.
The resulting type would probably be four bytes long, even if
you create a one byte by-value data type.  The one byte would
be packaged in a 4 byte container for passing around the server.

Can anyone confirm or deny this?  This was certainly the
case in Informix and Illustra.

--elein
elein@varlena.com

On Fri, Oct 10, 2003 at 11:37:14AM -0700, CSN wrote:
>
> Would you be able to roll your own int1's with types?
>
> http://www.postgresql.org/docs/7.3/interactive/xtypes.html
>
> CSN
>
>
> __________________________________
> Do you Yahoo!?
> The New Yahoo! Shopping - with improved product search
> http://shopping.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

pgsql-general by date:

Previous
From: Jan Wieck
Date:
Subject: Re: Replication Bundled with Main Source.
Next
From: Greg Stark
Date:
Subject: Re: log_duration and \timing times repeatably much higher than "Total runtime" from explain analyze