Re: Returning bytea* from a C function

Поиск
Список
Период
Сортировка
От Joe Conway
Тема Re: Returning bytea* from a C function
Дата
Msg-id 3D2B111F.5090506@joeconway.com
обсуждение исходный текст
Ответ на Returning bytea* from a C function  (David Busby <busby@pnts.com>)
Список pgsql-general
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



В списке pgsql-general по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: I am being interviewed by OReilly
Следующее
От: Robert L Mathews
Дата:
Сообщение: Re: Query Casting Help