Re: Postgres Wishlist
От
Michael Glaesemann
Тема
Re: Postgres Wishlist
Дата
Msg-id
C6A31827-F349-459E-A5F9-5CD682C002C8@seespotcode.net
Ответ на
Re: Postgres Wishlist (Donald Kerr)
Список
Дерево обсуждения
Hex to Dec Conversion "Donald Kerr" <donald.kerr@dkerr.co.uk>
Re: Hex to Dec Conversion Josh Kupershmidt <schmiddy@gmail.com>
Postgres Wishlist "Donald Kerr" <donald.kerr@dkerr.co.uk>
Re: Postgres Wishlist Steve Crawford <scrawford@pinpointresearch.com>
Re: Postgres Wishlist "Donald Kerr" <donald.kerr@dkerr.co.uk>
Re: Postgres Wishlist Tom Lane <tgl@sss.pgh.pa.us>
Re: Postgres Wishlist Steve Crawford <scrawford@pinpointresearch.com>
Re: Postgres Wishlist "Donald Kerr" <donald.kerr@dkerr.co.uk>
Re: Postgres Wishlist Michael Glaesemann <grzm@seespotcode.net>
Re: Postgres Wishlist Mladen Gogala <mladen.gogala@vmsinfo.com>
Re: Postgres Wishlist Mladen Gogala <mladen.gogala@vmsinfo.com>
Re: Postgres Wishlist Michael Wood <esiotrot@gmail.com>
Re: Postgres Wishlist "Donald Kerr" <donald.kerr@dkerr.co.uk>
Re: Postgres Wishlist Michael Wood <esiotrot@gmail.com>
Re: Postgres Wishlist "Donald Kerr" <donald.kerr@dkerr.co.uk>
Re: Postgres Wishlist "Donald Kerr" <donald.kerr@dkerr.co.uk>
Re: Postgres Wishlist Michael Glaesemann <grzm@seespotcode.net>
Re: Postgres Wishlist "Donald Kerr" <donald.kerr@dkerr.co.uk>
Re: Postgres Wishlist Mladen Gogala <mladen.gogala@vmsinfo.com>
Re: Hex to Dec Conversion "Donald Kerr" <donald.kerr@dkerr.co.uk>
On Nov 13, 2010, at 3:32 , Donald Kerr wrote:
> Thank you, Tom.
>
> I have tried what you suggest but it does not seem to work:
> 'x'||substring(col,3,2)::text::bit(8)::int returns - "9" is not a valid
> binary digit.
Try with parens:
postgres=# select ('x' || 99::text)::bit(8)::int;
int4
------
153
(1 row)
postgres=# select version();
version
------------------------------------------------------------------------------------------------------------------------------------------
PostgreSQL 9.0.1 on x86_64-apple-darwin10.4.0, compiled by GCC i686-apple-darwin10-gcc-4.2.1 (GCC) 4.2.1 (Apple Inc. build 5664), 64-bit
(1 row)
Michael Glaesemann
grzm seespotcode net
В списке pgsql-novice по дате отправления
