Re: [PATCH] Add function to_oct
От | Peter Eisentraut |
---|---|
Тема | Re: [PATCH] Add function to_oct |
Дата | |
Msg-id | 5c260f97-d8c8-4a68-7498-022e550c6b10@enterprisedb.com обсуждение исходный текст |
Ответ на | [PATCH] Add function to_oct (Eric Radman <ericshane@eradman.com>) |
Ответы |
Re: [PATCH] Add function to_oct
|
Список | pgsql-hackers |
On 20.12.22 23:08, Eric Radman wrote: > 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. Note this subsequent discussion about the to_hex function: https://www.postgresql.org/message-id/flat/CAEZATCVbkL1ynqpsKiTDpch34%3DSCr5nnau%3DnfNmiy2nM3SJHtw%40mail.gmail.com Also, I think there is no "to binary" function, so perhaps if we're going down this road one way or the other, we should probably complete the set.
В списке pgsql-hackers по дате отправления: