Thread: Simon Moses Qs

Simon Moses Qs

From
Simon Moses
Date:
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

Re: Simon Moses Qs

From
"Nick Fankhauser"
Date:
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@doxpop.com  Phone 1.765.965.7363  Fax 1.765.962.9788
doxpop  - Court records at your fingertips - http://www.doxpop.com/

Personal:
nick@fankhausers.com   http://www.fankhausers.com

-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of Simon Moses
Sent: Saturday, June 12, 2004 8:52 AM
To: pgsql-jdbc@postgresql.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