Обсуждение: Bug #650: LIKE command

Поиск
Список
Период
Сортировка

Bug #650: LIKE command

От
pgsql-bugs@postgresql.org
Дата:
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