Horton

[PATCH] Add function to_oct

Eric Radman <ericshane@eradman.com>

View thread View on postgr.es
From: Eric Radman <ericshane@eradman.com>
To: pgsql-hackers@postgresql.org
Date: 2022-12-20T22:08:13Z
Lists: pgsql-hackers

Attachments

Hello!

This patch is a new function based on the implementation of to_hex(int).

Since support for octal integer literals was added, to_oct(int) allows
octal values to be easily stored and returned in query results.

  to_oct(0o755) = '755'

This is probably most useful for storing file system permissions.

--
Eric Radman

Commits

  1. Add to_bin() and to_oct().