Re: [PATCH] Add function to_oct
От | Eric Radman |
---|---|
Тема | Re: [PATCH] Add function to_oct |
Дата | |
Msg-id | Y6JkciYiq4GqqEi4@vm3.eradman.com обсуждение исходный текст |
Ответ на | Re: [PATCH] Add function to_oct (Ian Lawrence Barwick <barwick@gmail.com>) |
Ответы |
Re: [PATCH] Add function to_oct
|
Список | pgsql-hackers |
On Wed, Dec 21, 2022 at 08:36:40AM +0900, Ian Lawrence Barwick wrote: > 2022年12月21日(水) 7:08 Eric Radman <ericshane@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? I couldn't think of a reason someone might want an octal representation of a bigint. Certainly it would be easy to add if there is value in supporting all of the same argument types.
В списке pgsql-hackers по дате отправления: