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