From: | "Nick Fankhauser" <nickf(at)ontko(dot)com> |
---|---|
To: | "Simon Moses" <ks_moses(at)yahoo(dot)com>, <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: Simon Moses Qs |
Date: | 2004-06-12 22:56:25 |
Message-ID: | NEBBLAAHGLEEPCGOBHDGMEIEMOAA.nickf@ontko.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Hi Simon-
You have the JDBC list here.
The SQL list might be a better place for future questions of this sort.
Here's one way to do it:
prod1=# create table testone (a boolean, b text);
CREATE TABLE
prod1=# insert into testone values ('t','true');
INSERT 485595194 1
prod1=# insert into testone values ('f','false');
INSERT 485595195 1
prod1=# select b || case when (a) then ' is true' else ' is false' end
prod1-# from testone;
?column?
----------------
true is true
false is false
(2 rows)
Regards,
-Nick
---------------------------------------------------------------------
Nick Fankhauser
Business:
nickf(at)doxpop(dot)com Phone 1.765.965.7363 Fax 1.765.962.9788
doxpop - Court records at your fingertips - http://www.doxpop.com/
Personal:
nick(at)fankhausers(dot)com http://www.fankhausers.com
-----Original Message-----
From: pgsql-jdbc-owner(at)postgresql(dot)org
[mailto:pgsql-jdbc-owner(at)postgresql(dot)org]On Behalf Of Simon Moses
Sent: Saturday, June 12, 2004 8:52 AM
To: pgsql-jdbc(at)postgresql(dot)org
Subject: [JDBC] Simon Moses Qs
dear sir,
i am using postgresql 7.2.
i want to concatenate 'character varying' and 'boolean' ex.
select character_varying_field||boolean_field as new_field from table_name;
or any function to convert 'boolean' to 'character varying' so that i can
use
select character_varying_field||convert_function(boolean_field) as new_field
from table_name;
thanks in advance
simon moses.
*********************************************************
Visit My Home Page updated: 20 June 2003.
Simon Moses
*********************************************************
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger
From | Date | Subject | |
---|---|---|---|
Next Message | Jouneau Luc | 2004-06-14 07:25:18 | Re: [ADMIN] doubt |
Previous Message | Simon Moses | 2004-06-12 13:52:08 | Simon Moses Qs |