DomainKey-Signature: a=rsa-sha1; c=nofws; d=eradman.com; h=date:from:to
	:cc:subject:message-id:references:mime-version:content-type
	:content-transfer-encoding:in-reply-to; q=dns; s=selector1; b=a5
	1BskQTzpw1GnCwZ7Vl+T/vzqAnvIF8Xx8nRHFkAXnhYB0DWi52spOW7sbezzS7P8
	ods0aNp1F3GQHa9MsL5eQCl4IjD9kY3KTdqBEBoTNPocvwROl8LcueCb6jtT4WhS
	Ac/qXG8y/i8fSdqX1ZJvd9syyFOLUnCzV2rauL6hg=
Date: Tue, 20 Dec 2022 20:42:10 -0500
From: Eric Radman <ericshane@eradman.com>
To: Ian Lawrence Barwick <barwick@gmail.com>
Cc: pgsql-hackers@postgresql.org
Subject: Re: [PATCH] Add function to_oct
Message-ID: <Y6JkciYiq4GqqEi4@vm3.eradman.com>
References: <Y6IyTQQ/TsD5wnsH@vm3.eradman.com>
 <CAB8KJ=ijh9iibwtB_5MQktUcZoe15FfNzAXNYUwnbxR7OKmHkQ@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: 
 <CAB8KJ=ijh9iibwtB_5MQktUcZoe15FfNzAXNYUwnbxR7OKmHkQ@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/Y6JkciYiq4GqqEi4%40vm3.eradman.com>
Precedence: bulk

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.