I have a bit string , 7 bits, every bit representing a day of the week. e.g. 1110011.
Is there and easy way where I can translate/format that string in a query.
I want to give the string back with a '-' for every 0 and the first char of the Day for every '1'.
example 1100111 = SM--TFS.
thanks for any suggestions Alex
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
