You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Thomas D'Silva (JIRA)" <ji...@apache.org> on 2014/05/21 22:42:38 UTC
[jira] [Created] (PHOENIX-995) ADD TO_STRING AND LPAD functions
Thomas D'Silva created PHOENIX-995:
--------------------------------------
Summary: ADD TO_STRING AND LPAD functions
Key: PHOENIX-995
URL: https://issues.apache.org/jira/browse/PHOENIX-995
Project: Phoenix
Issue Type: New Feature
Reporter: Thomas D'Silva
Add TO_STRING(input number, base number) which can be used to convert a base 10 number to a number in any base between 2 to 62.
Add LPAD(input string, length int [, fill string]) which can be used to left pad an input string.
Together these two functions can be used to generate IDs using sequences, for example:
{code:sql}
CREATE SEQUENCE foo.bar START WITH 0 INCREMENT BY 62
SELECT LPAD(TO_STRING(NEXT VALUE FOR foo.bar,62), 10,'0') FROM SYSTEM."SEQUENCE"
{code}
--
This message was sent by Atlassian JIRA
(v6.2#6252)