Hi!

In PSQL, how to check 4th bit of Integer type which is 1 or 0.



Thanks.






Mr. Phạm Hữu Lê Quốc Phục

* Add: 15 Quang Trung Street, Danang City, Vietnam
* Tel: 0511.810535 – Mobile: 0983.013467

_____

From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of miroslav_rajcic
Sent: Tuesday, June 12, 2007 16:03 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: How to concatenate strings in UPDATE statement ?

--- In firebird-support@ <mailto:firebird-support%40yahoogroups.com> yahoogroups.com, "Sasha" <selectnull@...> wrote:
> Try this
> update projects set code = 'JP' || substring(code from 1 for 3)
>
> Firebird Release Notes, page 28
>
> Sasha

Thanks everyone for the help. The working version is actually:

update projects set code = 'JP' || substring(code from 3)

Regards,
Miroslav





[Non-text portions of this message have been removed]