Bug #650: LIKE command - Mailing list pgsql-bugs

From pgsql-bugs@postgresql.org
Subject Bug #650: LIKE command
Date
Msg-id 20020430100403.E947047594B@postgresql.org
Whole thread Raw
List pgsql-bugs
Bob Kenny (bob@linkmed.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
before7.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

pgsql-bugs by date:

Previous
From: "medassist"
Date:
Subject: problem with lo_import()
Next
From: Laurent Belmonte
Date:
Subject: timestamp in trigger