2022年12月21日(水) 7:08 Eric Radman <ericsh...@eradman.com>:> > 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.
Seems like it would be convenient to have. Any reason why there's no matching "to_oct(bigint)" version? Patch has been added to the next commitfest [1], thanks. [1] https://commitfest.postgresql.org/41/4071/ Regards Ian Barwick