| 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> 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>></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 </span></p>
<p><span class=rvts7>select 'test' || null as result</span></p>
<p><span class=rvts7>returns null, </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>-- </span></p>
<p><span class=rvts8>Best regards,</span></p>
<p><span class=rvts8> Andrew </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 |
| 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 |