Postgres Pro
Downloads
Home   >   mailing lists

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  (Richard Huxton <dev@archonet.com>)
Re: SELECT question  (Brent Wood <b.wood@niwa.co.nz>)
Re: SELECT question  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
List pgsql-general
Tree view 
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