Add build in function BIN_BIT, BIN_BIT_STR, BIN_TO_STR and BIN_TO_STR_LIST
--------------------------------------------------------------------------
Key: CORE-4029
URL: http://tracker.firebirdsql.org/browse/CORE-4029
Project: Firebird Core
Issue Type: New Feature
Components: Engine
Reporter: Karol Bieniaszewski
Priority: Minor
I know that we can write udf(and we have it) - but binary operations are common
and will be good to see this functions supported by engine itself
1. BIN_BIT(VALUE: INTEGER; BIT_NR: INTEGER)
SELECT BIN_TO_STR(19, 0) FROM RDB$DATABASE
result
1
SELECT BIN_TO_STR(19, 2) FROM RDB$DATABASE
result
0
#########################################################
2. BIN_BIT_STR(VALUE: INTEGER; BIT_NR: INTEGER; BIT_SET_VALUE: PCHAR;
BIT_NOT_SET_VALUE: PCHAR)
SELECT BIN_TO_STR(19, 0, 'YES', 'NO') FROM RDB$DATABASE
result
'YES'
SELECT BIN_TO_STR(19, 2, 'YES', 'NO') FROM RDB$DATABASE
result
'NO'
#########################################################
3. BIN_TO_STR(VALUE: Integer; BIT_COUNT: Integer)
SELECT BIN_TO_STR(19, 2) FROM RDB$DATABASE
result
'01'
SELECT BIN_TO_STR(19, 5) FROM RDB$DATABASE
'10011'
#########################################################
4. BIN_TO_STR_LIST(VALUE: Integer; BIT_COUNT: Integer; BIT_VALUE_LIST: PCHAR;
OUT_LIST_SEPARATOR: PCHAR)
SELECT BIN_TO_STR_LIST(19, 2, 'DELIVERED;RECIVED;CHECKED;POSTED;CREATED', ', ')
FROM RDB$DATABASE
result
'DELIVERED'
SELECT BIN_TO_STR_LIST(19, 5, 'DELIVERED;RECIVED;CHECKED;POSTED;CREATED', ', ')
FROM RDB$DATABASE
'DELIVERED, RECIVED, CREATED'
and sample with already implemented LIST function
SELECT BIN_TO_STR_LIST(19, 2, (SELECT LIST(VALUE, ';') FROM SOME_TABLE), ', ')
FROM RDB$DATABASE
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Master HTML5, CSS3, ASP.NET, MVC, AJAX, Knockout.js, Web API and
much more. Get web development skills now with LearnDevNow -
350+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122812
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
