Re: int1? types?

From: elein <elein(at)varlena(dot)com>
To: CSN <cool_screen_name90001(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: int1? types?
Date: 2003-10-10 23:53:55
Message-ID: 20031010165355.D6483@cookie.varlena.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)varlena(dot)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(at)postgresql(dot)org)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Greg Stark 2003-10-10 23:56:39 Re: log_duration and \timing times repeatably much higher than "Total runtime" from explain analyze
Previous Message Jan Wieck 2003-10-10 23:15:37 Re: Replication Bundled with Main Source.