SELECT question - Mailing list pgsql-general

From Alex
Subject SELECT question
Date
Msg-id 3FA7857E.9080903@meerkatsoft.com
Whole thread Raw
Responses Re: SELECT question
Re: SELECT question
Re: SELECT question
List pgsql-general
Hi,

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







pgsql-general by date:

Previous
From: Max Speransky
Date:
Subject: Obtain boolean value of expression in PLPGSQL
Next
From: Richard Huxton
Date:
Subject: Re: Obtain boolean value of expression in PLPGSQL