Postgres Pro
Downloads
Home   >   mailing lists

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

From Eric Radman
Subject [PATCH] Add function to_oct
Date
Msg-id Y6IyTQQ/TsD5wnsH@vm3.eradman.com
Whole thread Raw
Responses Re: [PATCH] Add function to_oct
Re: [PATCH] Add function to_oct
List pgsql-hackers
Tree view 
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.

--
Eric Radman
Attachment

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: appendBinaryStringInfo stuff
Next
From: Peter Smith
Date:
Subject: Re: pgsql: Doc: Explain about Column List feature.