Message-ID: <50F56FF7.9000701@gmail.com>
Date: Tue, 15 Jan 2013 08:04:23 -0700
From: Rob Sargent <robjsargent@gmail.com>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
	rv:17.0) Gecko/20130106 Thunderbird/17.0.2
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Re: Why doesn't this work
References: <1358250600.37670.YahooMailNeo@web162804.mail.bf1.yahoo.com>
In-Reply-To: <1358250600.37670.YahooMailNeo@web162804.mail.bf1.yahoo.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

On 01/15/2013 04:50 AM, Barbara Woolums wrote:
> I am running a query like so
>
> SELECT id FROM image WHERE image='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
> "demo-scan0001.jpg";5
> "demo-cherry-chocolate-mousse-pie.jpg";6
> "demo-harvey wallbanger.jpg
> ";7
>
> Cheers
> Barbara

Try select id from image where image.image ~'demo-harvey wallbanger';

If you example data is correct, I think you have a line-feed char after 
'.jpg'


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql