Simon Moses Qs - Mailing list pgsql-jdbc

From Simon Moses
Subject Simon Moses Qs
Date
Msg-id 20040612135208.12853.qmail@web14923.mail.yahoo.com
Whole thread Raw
Responses Re: Simon Moses Qs  ("Nick Fankhauser" <nickf@ontko.com>)
List pgsql-jdbc
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

pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Trouble with locking tables - reg.
Next
From: "Nick Fankhauser"
Date:
Subject: Re: Simon Moses Qs