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
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 |