Skip site navigation (1) Skip section navigation (2)

Re: Postgres Wishlist

From: "Donald Kerr" <donald(dot)kerr(at)dkerr(dot)co(dot)uk>
To: "'Michael Glaesemann'" <grzm(at)seespotcode(dot)net>
Cc: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>,"'Steve Crawford'" <scrawford(at)pinpointresearch(dot)com>,<pgsql-novice(at)postgresql(dot)org>
Subject: Re: Postgres Wishlist
Date: 2010-11-13 08:53:47
Message-ID: 2AD99D319C894638AF192798318FB445@DELLM4500 (view raw or flat)
Thread:
Lists: pgsql-novice
Michael,

First class :) Problem solved!!!

=======================
SELECT col, ('x'||substring(col,1,2))::text::bit(8)::int || ' ' ||
('x'||substring(col,3,2))::text::bit(8)::int || ' ' ||
('x'||substring(col,1,2))::text::bit(8)::int AS oscolor FROM
cartographictext WHERE COL <> '000000' LIMIT 10

Returns:
"0099FF";"0 153 0"
"FF00FF";"255 0 255"
Etc.

Thank you very much to everyone who helped me with this problem. 

Regards,

Donald




-----Original Message-----
From: Michael Glaesemann [mailto:grzm(at)seespotcode(dot)net] 
Sent: 13 November 2010 08:45
To: Donald Kerr
Cc: 'Tom Lane'; 'Steve Crawford'; pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] Postgres Wishlist 



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


In response to

Responses

pgsql-novice by date

Next:From: Michael GlaesemannDate: 2010-11-13 10:00:30
Subject: Re: Postgres Wishlist
Previous:From: Donald KerrDate: 2010-11-13 08:46:03
Subject: Re: Postgres Wishlist

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group