Re: [PATCH] Add function to_oct - Mailing list pgsql-hackers

From Eric Radman
Subject Re: [PATCH] Add function to_oct
Date
Msg-id Y6JkciYiq4GqqEi4@vm3.eradman.com
Whole thread Raw
In response to Re: [PATCH] Add function to_oct  (Ian Lawrence Barwick <barwick@gmail.com>)
Responses Re: [PATCH] Add function to_oct  (Ian Lawrence Barwick <barwick@gmail.com>)
List 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 by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Use get_call_result_type() more widely
Next
From: Michael Paquier
Date:
Subject: Re: Simplifications for error messages related to compression