Add bytea equivalents of ltrim() and rtrim().
Tom Lane <tgl@sss.pgh.pa.us>
Add bytea equivalents of ltrim() and rtrim(). We had bytea btrim() already, but for some reason not the other two. Joel Jacobson Discussion: https://postgr.es/m/d10cd5cd-a901-42f1-b832-763ac6f7ff3a@www.fastmail.com
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/func.sgml | modified | +45 −4 |
| src/backend/utils/adt/oracle_compat.c | modified | +113 −39 |
| src/backend/utils/adt/ruleutils.c | modified | +2 −0 |
| src/include/catalog/catversion.h | modified | +1 −1 |
| src/include/catalog/pg_proc.dat | modified | +7 −1 |
| src/test/regress/expected/create_view.out | modified | +8 −2 |
| src/test/regress/expected/strings.out | modified | +12 −0 |
| src/test/regress/sql/create_view.sql | modified | +4 −1 |
| src/test/regress/sql/strings.sql | modified | +2 −0 |
Documentation touched
Discussion
- [PATCH] Add support for leading/trailing bytea trim()ing 6 messages · 2020-12-04 → 2021-01-18