Re: [JDBC] concat returns null

 Hello abyss,

Check out the built-in function COALESCE which will do your special-casing for you

Tuesday, December 18, 2007, 3:16:31 AM, you wrote:

>

I don't know if it's bug or feature but  select 'test' || null as result Do you need help? In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related postgresql.org Links pgsql-admin pgsql-advocacy pgsql-announce pgsql-bugs pgsql-cygwin pgsql-docs pgsql-general pgsql-interfaces pgsql-jdbc pgsql-jobs pgsql-novice pgsql-odbc pgsql-performance pgsql-php pgsql-ports pgsql-sql Request more information about Pantek returns null,  so i need to case second parameter not to concat if it is null...

-- 

Do you need more help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related postgresql.org Links pgsql-admin pgsql-advocacy pgsql-announce pgsql-bugs pgsql-cygwin pgsql-docs pgsql-general pgsql-interfaces pgsql-jdbc pgsql-jobs pgsql-novice pgsql-odbc pgsql-performance pgsql-php pgsql-ports pgsql-sql Request more information about Pantek

Best regards,

 Andrew                            mailto:drlaz@attglobal.netReceived on Tue Dec 25 22:51:26 2007

This archive was generated by hypermail 2.1.8 : Wed Jun 18 2008 - 23:41:55 EDT