Re: Using TEXT columns for binary content

Поиск
Список
Период
Сортировка
От Lamar Owen
Тема Re: Using TEXT columns for binary content
Дата
Msg-id 200304211218.57267.lamar.owen@wgcr.org
обсуждение исходный текст
Ответ на Re: Using TEXT columns for binary content  (Joe Conway <mail@joeconway.com>)
Список pgsql-general
On Monday 21 April 2003 12:01, Joe Conway wrote:
> Mircea Sarbu wrote:
> > There are some hidden drawbacks for this approach? (I don't need any
> > further processing on the binary content)

> There are people who have reported using this method successfully on the
> Postgres lists. Only downsides I can think of are:

> 1) You have to encode to base64 on the way in (bytea has to be escaped
>     on INSERT/UPDATE too)

OpenACS uses this technique.  The PostgreSQL driver for AOLserver (which
OpenACS uses) has code -- aolserver.sourceforge.net -- files, nspostgres.
GPL/APL dual-licensed, if that matters.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11


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

Предыдущее
От: Murthy Kambhampaty
Дата:
Сообщение: Re: stddev returns 0 when there is one row
Следующее
От: Tom Lane
Дата:
Сообщение: Re: stddev returns 0 when there is one row