Bug #650: LIKE command

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #650: LIKE command
Date: 2002-04-30 10:04:03
Message-ID: 20020430100403.E947047594B@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Bob Kenny (bob(at)linkmed(dot)org) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
LIKE command

Long Description
Using the LIKE command in a SELECT statement doesnt work now unless a regular expression is in the string. This worked before 7.2. I am running 7.2 under Solaris 2.6 & 8

Sample Code
SELECT AccNum , StuID , StuInsUID , RefPhyNam , StuDes , PatAge , PatSiz , PatWei , Owner , GroupName , Priv , PatParent , StuDat , StuTim , InsertDate , InsertTime , NumStuRelSer , NumStuRelIma FROM StudyLevel WHERE StuInsUID like '1.2.826.0.1.4156771.2155605229.6692.1020158785.1' AND PatParent = 'BONES';

No file was uploaded with this report

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2002-04-30 14:03:20 Re: LIKE Command
Previous Message Bob Kenny 2002-04-30 09:46:05 LIKE Command