Re: Error in SELECT clause with UPPER function

From: "Lee Crampton" <lee(at)avbrief(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Error in SELECT clause with UPPER function
Date: 2002-11-15 22:09:57
Message-ID: ar3r5c$2m74$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Sorry, can't help with 7.2.3 but it does work with 7.2.1 in similar
circumstances:

version
-------------------------------------------------------------
PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.96

psql avbrief -c "select userid,upper(userid) from users where
userid='sdclee'"
userid | upper
--------+--------
sdclee | SDCLEE
(1 row)

psql avbrief -c "select userid,upper(userid) from users where
upper(userid)='SDCLEE'"

userid | upper
--------+--------
sdclee | SDCLEE
(1 row)

However, looking at your output, it looks like 'ADMIN' may be 'ADMIN ', so
check that out.
To prove it, how about :

> track=# select loginname, upper(loginname) from tperson where
> upper(loginname) like 'ADMIN%';

Hope that helps
Lee Crampton

""Pascal Rempenault"" <prempenault(at)hubwoo(dot)com> wrote in message
news:NEBBIINNELNNLHDBPCCIMEAADLAA(dot)prempenault(at)hubwoo(dot)com(dot)(dot)(dot)
> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_0017_01C28A4A.994F01A0
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: 8bit
>
> 1) Using
> PostgreSQL 7.2.3 on i586-pc-linux-gnu, compiled by GCC 2.95.3
>
>
> 2) Description
>
> track=# select loginname, upper(loginname) from tperson;
> loginname | upper
> ------------+------------
> admin | ADMIN
> prempena | PREMPENA
> (2 rows)
>
> track=# select loginname, upper(loginname) from tperson where
> upper(loginname)='ADMIN';
> loginname | upper
> -----------+-------
> (0 rows)
>
>
> 3) Expected result
> loginname | upper
> ------------+------------
> admin | ADMIN
> (1 row)
>
> If someone can help to understand why .
>
> Thanks in advance.
>
> Pascal
>
> ------=_NextPart_000_0017_01C28A4A.994F01A0
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> <html xmlns:o=3D"urn:schemas-microsoft-com:office:office"
xmlns:w=3D"urn:sc=
> hemas-microsoft-com:office:word"
xmlns=3D"http://www.w3.org/TR/REC-html40">
>
> <head>
> <meta http-equiv=3DContent-Type content=3D"text/html;
charset=3Diso-8859-1">
> <meta name=3DProgId content=3DWord.Document>
> <meta name=3DGenerator content=3D"Microsoft Word 9">
> <meta name=3DOriginator content=3D"Microsoft Word 9">
> <link rel=3DFile-List href=3D"cid:filelist(dot)xml(at)01C28A4A(dot)95D56B40">
> <!--[if gte mso 9]><xml>
> <o:OfficeDocumentSettings>
> <o:DoNotRelyOnCSS/>
> </o:OfficeDocumentSettings>
> </xml><![endif]--><!--[if gte mso 9]><xml>
> <w:WordDocument>
> <w:View>Normal</w:View>
> <w:Zoom>0</w:Zoom>
> <w:DocumentKind>DocumentEmail</w:DocumentKind>
> <w:HyphenationZone>21</w:HyphenationZone>
> <w:EnvelopeVis/>
> </w:WordDocument>
> </xml><![endif]-->
> <style>
> <!--
> /* Font Definitions */
> @font-face
> {font-family:Tahoma;
> panose-1:2 11 6 4 3 5 4 4 2 4;
> mso-font-charset:0;
> mso-generic-font-family:swiss;
> mso-font-pitch:variable;
> mso-font-signature:16792199 0 0 0 65791 0;}
> /* Style Definitions */
> p.MsoNormal, li.MsoNormal, div.MsoNormal
> {mso-style-parent:"";
> margin:0cm;
> margin-bottom:.0001pt;
> mso-pagination:widow-orphan;
> font-size:12.0pt;
> font-family:"Times New Roman";
> mso-fareast-font-family:"Times New Roman";}
> p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
> {margin:0cm;
> margin-bottom:.0001pt;
> mso-pagination:widow-orphan;
> font-size:12.0pt;
> font-family:"Times New Roman";
> mso-fareast-font-family:"Times New Roman";}
> span.StyleCourrierlectronique15
> {mso-style-type:personal-compose;
> mso-ansi-font-size:10.0pt;
> mso-ascii-font-family:Arial;
> mso-hansi-font-family:Arial;
> mso-bidi-font-family:Arial;
> color:black;}
> @page Section1
> {size:595.3pt 841.9pt;
> margin:70.85pt 70.85pt 70.85pt 70.85pt;
> mso-header-margin:35.4pt;
> mso-footer-margin:35.4pt;
> mso-paper-source:0;}
> div.Section1
> {page:Section1;}
> -->
> </style>
> </head>
>
> <body lang=3DFR style=3D'tab-interval:35.4pt'>
>
> <div class=3DSection1>
>
> <p class=3DMsoNormal><font size=3D2 color=3Dblack face=3D"Courier
New"><span
> lang=3DEN-GB style=3D'font-size:10.0pt;font-family:"Courier
New";color:blac=
> k;
> mso-ansi-language:EN-GB'>1) Using&nbsp; </span></font><font size=3D1
color=
> =3Dblack
> face=3DTahoma><span lang=3DEN-GB
style=3D'font-size:8.5pt;font-family:Tahom=
> a;
> color:black;mso-ansi-language:EN-GB'><o:p></o:p></span></font></p>
>
> <p class=3DMsoNormal><font size=3D2 color=3Dblack face=3D"Courier
New"><span
> lang=3DEN-GB style=3D'font-size:10.0pt;font-family:"Courier
New";color:blac=
> k;
> mso-ansi-language:EN-GB'>PostgreSQL 7.2.3 on i586-pc-linux-gnu, compiled
by=
> GCC
> 2.95.3</span></font><font size=3D1 color=3Dblack face=3DTahoma><span lang=
> =3DEN-GB
>
style=3D'font-size:8.5pt;font-family:Tahoma;color:black;mso-ansi-language:E=
> N-GB'><o:p></o:p></span></font></p>
>
> <p class=3DMsoNormal><font size=3D1 color=3Dblack face=3DTahoma><span
lang=
> =3DEN-GB
>
style=3D'font-size:8.5pt;font-family:Tahoma;color:black;mso-ansi-language:E=
> N-GB'>&nbsp;<o:p></o:p></span></font></p>
>
> <p class=3DMsoNormal><font size=3D2 color=3Dblack face=3D"Courier
New"><span
> lang=3DEN-GB style=3D'font-size:10.0pt;font-family:"Courier
New";color:blac=
> k;
> mso-ansi-language:EN-GB'><![if
!supportEmptyParas]>&nbsp;<![endif]><o:p></o=
> :p></span></font></p>
>
> <p class=3DMsoNormal><font size=3D2 color=3Dblack face=3D"Courier
New"><span
> lang=3DEN-GB style=3D'font-size:10.0pt;font-family:"Courier
New";color:blac=
> k;
> mso-ansi-language:EN-GB'>2) Description<o:p></o:p></span></font></p>
>
> <p class=3DMsoNormal><font size=3D1 color=3Dblack face=3DTahoma><span
lang=
> =3DEN-GB
>
style=3D'font-size:8.5pt;font-family:Tahoma;color:black;mso-ansi-language:E=
> N-GB'><![if
!supportEmptyParas]>&nbsp;<![endif]><o:p></o:p></span></font></=
> p>
>
> <p class=3DMsoNormal><font size=3D2 color=3Dblack face=3D"Courier
New"><span
> lang=3DEN-GB style=3D'font-size:10.0pt;font-family:"Courier
New";color:blac=
> k;
> mso-ansi-language:EN-GB'>track=3D# select loginname, upper(loginname) from
> tperson;<br>
> &nbsp;loginname&nbsp; |&nbsp;&nbsp; upper<br>
> ------------+------------<br>
> &nbsp;admin&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | ADMIN<br>
> &nbsp;prempena&nbsp;&nbsp; | PREMPENA<br>
> (2 rows)</span></font><font size=3D1 color=3Dblack face=3DTahoma><span
lang=
> =3DEN-GB
>
style=3D'font-size:8.5pt;font-family:Tahoma;color:black;mso-ansi-language:E=
> N-GB'><o:p></o:p></span></font></p>
>
> <p class=3DMsoNormal><font size=3D1 color=3Dblack face=3DTahoma><span
lang=
> =3DEN-GB
>
style=3D'font-size:8.5pt;font-family:Tahoma;color:black;mso-ansi-language:E=
> N-GB'>&nbsp;<o:p></o:p></span></font></p>
>
> <p class=3DMsoNormal><font size=3D2 color=3Dblack face=3D"Courier
New"><span
> lang=3DEN-GB style=3D'font-size:10.0pt;font-family:"Courier
New";color:blac=
> k;
> mso-ansi-language:EN-GB'>track=3D# select loginname, upper(loginname) from
> tperson where upper(loginname)=3D'ADMIN';<br>
> &nbsp;loginname | upper<br>
> -----------+-------<br>
> (0 rows)<o:p></o:p></span></font></p>
>
> <p class=3DMsoNormal><font size=3D2 color=3Dblack face=3D"Courier
New"><span
> lang=3DEN-GB style=3D'font-size:10.0pt;font-family:"Courier
New";color:blac=
> k;
> mso-ansi-language:EN-GB'><![if
!supportEmptyParas]>&nbsp;<![endif]><o:p></o=
> :p></span></font></p>
>
> <p class=3DMsoNormal><font size=3D2 color=3Dblack face=3D"Courier
New"><span
> lang=3DEN-GB style=3D'font-size:10.0pt;font-family:"Courier
New";color:blac=
> k;
> mso-ansi-language:EN-GB'><![if
!supportEmptyParas]>&nbsp;<![endif]><o:p></o=
> :p></span></font></p>
>
> <p class=3DMsoNormal><font size=3D2 color=3Dblack face=3D"Courier
New"><span
> lang=3DEN-GB style=3D'font-size:10.0pt;font-family:"Courier
New";color:blac=
> k;
> mso-ansi-language:EN-GB'>3) Expected result</span></font><font size=3D1
> color=3Dblack face=3DTahoma><span lang=3DEN-GB
style=3D'font-size:8.5pt;fon=
> t-family:
> Tahoma;color:black;mso-ansi-language:EN-GB'><o:p></o:p></span></font></p>
>
> <p class=3DMsoNormal><font size=3D2 color=3Dblack face=3D"Courier
New"><span
> lang=3DEN-GB style=3D'font-size:10.0pt;font-family:"Courier
New";color:blac=
> k;
> mso-ansi-language:EN-GB'>&nbsp;loginname&nbsp; |&nbsp;&nbsp; upper<br>
> ------------+------------<br>
> &nbsp;admin&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | ADMIN<br>
> (1 row)</span></font><font size=3D1 color=3Dblack face=3DTahoma><span
lang=
> =3DEN-GB
>
style=3D'font-size:8.5pt;font-family:Tahoma;color:black;mso-ansi-language:E=
> N-GB'><o:p></o:p></span></font></p>
>
> <p class=3DMsoNormal><font size=3D1 color=3Dblack face=3DTahoma><span
lang=
> =3DEN-GB
>
style=3D'font-size:8.5pt;font-family:Tahoma;color:black;mso-ansi-language:E=
> N-GB'>&nbsp;<o:p></o:p></span></font></p>
>
> <p class=3DMsoNormal><font size=3D2 color=3Dblack face=3D"Courier
New"><span
> lang=3DEN-GB style=3D'font-size:10.0pt;font-family:"Courier
New";color:blac=
> k;
> mso-ansi-language:EN-GB'>If someone can help to understand why
&#8230;<o:p>=
> </o:p></span></font></p>
>
> <p class=3DMsoNormal><font size=3D2 color=3Dblack face=3D"Courier
New"><span
> lang=3DEN-GB style=3D'font-size:10.0pt;font-family:"Courier
New";color:blac=
> k;
> mso-ansi-language:EN-GB'><![if
!supportEmptyParas]>&nbsp;<![endif]><o:p></o=
> :p></span></font></p>
>
> <p class=3DMsoNormal><font size=3D2 color=3Dblack face=3D"Courier
New"><span
> lang=3DEN-GB style=3D'font-size:10.0pt;font-family:"Courier
New";color:blac=
> k;
> mso-ansi-language:EN-GB'>Thanks in advance.</span></font><font size=3D1
> color=3Dblack face=3DTahoma><span lang=3DEN-GB
style=3D'font-size:8.5pt;fon=
> t-family:
> Tahoma;color:black;mso-ansi-language:EN-GB'><o:p></o:p></span></font></p>
>
> <p class=3DMsoNormal><font size=3D1 color=3Dblack face=3DTahoma><span
lang=
> =3DEN-GB
>
style=3D'font-size:8.5pt;font-family:Tahoma;color:black;mso-ansi-language:E=
> N-GB'>&nbsp;<o:p></o:p></span></font></p>
>
> <p class=3DMsoNormal><font size=3D2 color=3Dblack face=3D"Courier
New"><span
> style=3D'font-size:10.0pt;font-family:"Courier
New";color:black'>Pascal</sp=
> an></font><span
> class=3DStyleCourrierlectronique15><font size=3D2 color=3Dblack
face=3DAria=
> l><span
>
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'><o:p=
> ></o:p></span></font></span></p>
>
> </div>
>
> </body>
>
> </html>
>
> ------=_NextPart_000_0017_01C28A4A.994F01A0--
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-11-15 22:11:48 Re: Installing PostgreSQL on HPUX 11i (with TCL) -- how does one do it
Previous Message Harald Armin Massa 2002-11-15 21:20:40 Doing sth. like oracles "connect by"