Re: 9.4. String Functions and Operators page does not document thatencode adds line breaks - Mailing list pgsql-docs

From Alvaro Herrera
Subject Re: 9.4. String Functions and Operators page does not document thatencode adds line breaks
Date
Msg-id 20200227183256.GA30538@alvherre.pgsql
Whole thread Raw
In response to Re: 9.4. String Functions and Operators page does not document thatencode adds line breaks  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: 9.4. String Functions and Operators page does not document thatencode adds line breaks
List pgsql-docs
On 2020-Feb-09, David G. Johnston wrote:

> Stating direct RFC4648 compliance would require us to drop the line breaks
> that are only being added due to using MIME rules which ideally our general
> encoding function would not do.  Greenfield we probably would want base64
> to be general RFC4648 and add something like base64-mime which performs the
> line breaking for the user per RFC 2045, base64-pem which would use that
> specific environments RFC rules.  Now, maybe we can add "base64-4648" or
> "base64-general" while leaving "base64" alone and using the MIME version of
> the rules?

Patches welcome.

I'm not sure that we *need* to preserve the historical behavior.  Many
people would probably be okay with encode('base64') returning no
newlines (since they are useless most of the time anyway), and the
minority that does can use encode('base64-rfc2045').

Another idea might be to add an optional 'flags' option to encode(),
which are given to the encoder/decoder functions.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



pgsql-docs by date:

Previous
From: PG Doc comments form
Date:
Subject: thoroughly broken examples on the Dynamic SQL page
Next
From: Laurenz Albe
Date:
Subject: Re: thoroughly broken examples on the Dynamic SQL page