Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tv51r-00033H-Lv for pgsql-sql@arkaria.postgresql.org; Tue, 15 Jan 2013 11:50:08 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1Tv51r-0003dk-6f for pgsql-sql@arkaria.postgresql.org; Tue, 15 Jan 2013 11:50:07 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tv51q-0003dd-Dm for pgsql-sql@postgresql.org; Tue, 15 Jan 2013 11:50:06 +0000 Received: from nm4.bullet.mail.bf1.yahoo.com ([98.139.212.163]) by magus.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1Tv51n-0008OE-5N for pgsql-sql@postgresql.org; Tue, 15 Jan 2013 11:50:05 +0000 Received: from [98.139.212.151] by nm4.bullet.mail.bf1.yahoo.com with NNFMP; 15 Jan 2013 11:50:01 -0000 Received: from [98.139.212.207] by tm8.bullet.mail.bf1.yahoo.com with NNFMP; 15 Jan 2013 11:50:01 -0000 Received: from [127.0.0.1] by omp1016.mail.bf1.yahoo.com with NNFMP; 15 Jan 2013 11:50:01 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 335525.21325.bm@omp1016.mail.bf1.yahoo.com Received: (qmail 63929 invoked by uid 60001); 15 Jan 2013 11:50:01 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ymail.com; s=s1024; t=1358250601; bh=W+SZdeiaOi+xIVYGBWzpGew+WflOcFKGfb+IME7uibM=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=6do6NKmAxsFIUIG35K/dmrySgO5qCku/MoXXJJDmNScN5vN/uK3ujSnbKeczkOWqMystyrgFJrkCJb5TdmokzMjFSd0G4RPrkqHQq1EI7evNIk7781svDwTXxn2FMy4jAG7gs1dvA8LzJfnsGyjxFaY8oV5h2Hg41Ldx9eNbuGw= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=ymail.com; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=ZKktCsYCEfK5Ty58ayEUENb0JIRqtwAGlbMhsM6wiXZuo06se4rtDqfgaFQz8K0zDk0ljMSrOG06SunHe0LTXZ35Y6Ebumb4L4LlRyhHzKnaMwo7AZU+OyjGFr6pBWoNYeCs/7RaiZlK7Cl2Sf8l9ZF8P8qUH+3YXugvAxKndkY=; X-YMail-OSG: d8999SwVM1mELUp1pzyRapEKu76L_vCPBOkyx804CLMC3sO KNpAT2PGp9eJZh6iig3ImKk_7911Y1B8YqhXJOb143RAKByC75ToNq7vWxt1 S1K4gkYwy0WpkZfh1rqmY.WA09QC6hNbLBwg3RXnTUcVEDudHuS6xY9amCkr sn70wS.CjMBvd4QEACYTkblIeXaneSh1phVcXO1oWjN4Rx12bna625pLwYqD UEgsgntYjlHv5WqJnKu5YSx83bp2mK65oNADLf6lquvIfAD19D9kuK4bJz8E 77J5PraukVI.oTfoSncETS1s6LTZ6MUM8lF5t2HWgIXBdGJexeiq4jLQ4S4c am8rtP4YbCx6CJ6ZSZcnC.S7MXep_yU06NgGZ_HeXk8JTsv1rgHDYXoqhNcm xozLOxL86bAqa_v6eiqwQenFTUoAEFY7urGLMFx5j3wCo8_aHk9eqiQEelBT OUyxOvIB4z13pc3KkTONUTu0xFTtis_bCee2_6pSGVCW1 Received: from [123.200.245.52] by web162804.mail.bf1.yahoo.com via HTTP; Tue, 15 Jan 2013 03:50:00 PST X-Rocket-MIMEInfo: 001.001, SSBhbSBydW5uaW5nIGEgcXVlcnkgbGlrZSBzbwoKU0VMRUNUIGlkIEZST00gaW1hZ2UgV0hFUkUgaW1hZ2U9J2RlbW8taGFydmV5IHdhbGxiYW5nZXIuanBnJwoKSXQgcmV0dXJucyBub3RoaW5nCgpNeSB0YWJsZSBsb29rcyBsaWtlIHRoaXMKCiJkZW1vLTgyMC5qcGciOzEKImRlbW8tbGVtb24tbW91c3NlLTEuanBnIjsyCiJkZW1vLXB1bXBraW5jaGFpYmFycy5qcGciOzMKImRlbW8tTG9sbHktU2hvcC5qcGciOzQKImRlbW8tc2NhbjAwMDEuanBnIjs1CiJkZW1vLWNoZXJyeS1jaG9jb2xhdGUtbW91c3NlLXABMAEBAQE- X-Mailer: YahooMailWebService/0.8.130.494 Message-ID: <1358250600.37670.YahooMailNeo@web162804.mail.bf1.yahoo.com> Date: Tue, 15 Jan 2013 03:50:00 -0800 (PST) From: Barbara Woolums Reply-To: Barbara Woolums Subject: Why doesn't this work To: "pgsql-sql@postgresql.org" MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="-905771916-560856070-1358250600=:37670" X-Pg-Spam-Score: 0.7 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-sql Precedence: bulk Sender: pgsql-sql-owner@postgresql.org ---905771916-560856070-1358250600=:37670 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable I am running a query like so=0A=0ASELECT id FROM image WHERE image=3D'demo-= harvey wallbanger.jpg'=0A=0AIt returns nothing=0A=0AMy table looks like thi= s=0A=0A"demo-820.jpg";1=0A"demo-lemon-mousse-1.jpg";2=0A"demo-pumpkinchaiba= rs.jpg";3=0A"demo-Lolly-Shop.jpg";4=0A"demo-scan0001.jpg";5=0A"demo-cherry-= chocolate-mousse-pie.jpg";6=0A"demo-harvey wallbanger.jpg=0A";7=0A=0A=0A=A0= =0ACheers=0ABarbara=0A ---905771916-560856070-1358250600=:37670 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
I am runni= ng a query like so

SELEC= T id FROM image WHERE image=3D'demo-harvey wallbanger.jpg'

It returns nothing

My table looks like this
"demo-820.jpg";1
"demo-lemon-mousse-= 1.jpg";2
"demo-pumpkinchaibars.jpg";3
"demo-Lolly-Shop.jpg";4
"dem= o-scan0001.jpg";5
"demo-cherry-chocolate-mousse-pie.jpg";6
"demo-harv= ey wallbanger.jpg
";7

 
Cheers
= Barbara
---905771916-560856070-1358250600=:37670--