Thread: Returning bytea* from a C function

Returning bytea* from a C function

From
David Busby
Date:
List,
    I'm trying to build a function for PostgreSQL that allows me to create a
new UUID for data in my datbase.  Has anyone had experience with this
one?  I was going to store it as a bytea datatype, would a char(32) be
better?  Any Ideas?

/B




Re: Returning bytea* from a C function

From
Joe Conway
Date:
David Busby wrote:
> List,
>     I'm trying to build a function for PostgreSQL that allows me to
> create a new UUID for data in my datbase.  Has anyone had experience
> with this one?  I was going to store it as a bytea datatype, would a
> char(32) be better?  Any Ideas?
>

If your table will be very large, using bytea will save a fair amount of
space. Other possibilities are to encode the data into base64 or hex and
store in a TEXT (or VARCHAR or CHAR()) field.

Joe