Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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


pgsql-bugs by date

Next:From: Tom LaneDate: 2002-04-30 14:03:20
Subject: Re: LIKE Command
Previous:From: Bob KennyDate: 2002-04-30 09:46:05
Subject: LIKE Command

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group