Re: concat returns null

From: Andrew Lazarus <drlaz(at)attglobal(dot)net>
To: abyss <kurjak(at)gmail(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: concat returns null
Date: 2007-12-26 03:49:24
Message-ID: 536006520.20071225194924@attglobal.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html><head><title></title>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<meta http-equiv="Content-Style-Type" content="text/css">
<style type="text/css"><!--
body {
margin: 5px 5px 5px 5px;
background-color: #ffffff;
}
/* ========== Text Styles ========== */
hr { color: #000000}
body, table /* Normal text */
{
font-size: 12pt;
font-family: 'Garamond';
font-style: normal;
font-weight: normal;
color: #000000;
text-decoration: none;
}
span.rvts1 /* Heading */
{
font-size: 10pt;
font-family: 'Arial';
font-weight: bold;
color: #0000ff;
}
span.rvts2 /* Subheading */
{
font-size: 10pt;
font-family: 'Arial';
font-weight: bold;
color: #000080;
}
span.rvts3 /* Keywords */
{
font-size: 10pt;
font-family: 'Arial';
font-style: italic;
color: #800000;
}
a.rvts4, span.rvts4 /* Jump 1 */
{
font-size: 10pt;
font-family: 'Arial';
color: #008000;
text-decoration: underline;
}
a.rvts5, span.rvts5 /* Jump 2 */
{
font-size: 10pt;
font-family: 'Arial';
color: #008000;
text-decoration: underline;
}
span.rvts6
{
font-size: 9pt;
font-family: 'tahoma';
font-weight: bold;
color: #ffffff;
background-color: #0000ff;
}
span.rvts7
{
font-size: 9pt;
font-family: 'tahoma';
}
span.rvts8
{
font-size: 10pt;
font-family: 'gill sans mt';
font-style: italic;
color: #800000;
}
a.rvts9, span.rvts9
{
font-size: 10pt;
font-family: 'gill sans mt';
color: #0000ff;
text-decoration: underline;
}
/* ========== Para Styles ========== */
p,ul,ol /* Paragraph Style */
{
text-align: left;
text-indent: 0px;
padding: 0px 0px 0px 0px;
margin: 0px 0px 0px 0px;
}
.rvps1 /* Centered */
{
text-align: center;
}
--></style>
</head>
<body>

<p>&nbsp;Hello abyss,</p>
<p>Check out the built-in function COALESCE which will do your special-casing for you</p>
<p><br></p>
<p>Tuesday, December 18, 2007, 3:16:31 AM, you wrote:</p>
<p><br></p>
<div><table border=0 cellpadding=1 cellspacing=2>
<tr valign=top>
<td width=13 style="background-color: #0000ff;">
<p><span class=rvts6>&gt;</span></p>
</td>
<td width=1142 style="background-color: #ffffff;">
<p><span class=rvts7>I don't know if it's bug or feature but&nbsp;</span></p>
<p><span class=rvts7>select 'test' || null as result</span></p>
<p><span class=rvts7>returns null,&nbsp;</span></p>
<p><span class=rvts7>so i need to case second parameter not to concat if it is null...</span></p>
<p><br></p>
</td>
</tr>
</table>
</div>
<p><br></p>
<p><br></p>
<p><br></p>
<p><br></p>
<p><span class=rvts8>--&nbsp;</span></p>
<p><span class=rvts8>Best regards,</span></p>
<p><span class=rvts8>&nbsp;Andrew &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</span><a class=rvts9 href="mailto:drlaz(at)attglobal(dot)net">mailto:drlaz(at)attglobal(dot)net</a></p>

</body></html>

Attachment Content-Type Size
unknown_filename text/html 2.8 KB

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Daniel Migowski 2007-12-27 08:40:02 Re: TypeInfoCache
Previous Message Christian Schröder 2007-12-23 23:15:44 Re: Missing fields in getColumns() result