sub-select - Mailing list pgsql-general

From Henrik Steffen
Subject sub-select
Date
Msg-id 013001c31ab8$3cfe0190$9800a8c0@henrik
Whole thread Raw
Responses Re: sub-select
List pgsql-general
hello,

I am going crazy on this one:

select * from foo where bar like '0101%' and foobar='03997';

works fine (1 result). HOWEVER:

select * from foo where bar like '0101%' and foobar=ANY(SELECT
'03997'::TEXT);

does not work at all (no result)...

shouldn't this work usually???

am i missing something?

thanks anyone

--

Mit freundlichem Gruß

Henrik Steffen
Geschäftsführer

top concepts Internetmarketing GmbH
Am Steinkamp 7 - D-21684 Stade - Germany
--------------------------------------------------------
http://www.topconcepts.com          Tel. +49 4141 991230
mail: steffen@topconcepts.com       Fax. +49 4141 991233
--------------------------------------------------------
24h-Support Hotline:  +49 1908 34697 (EUR 1.86/Min,topc)
--------------------------------------------------------
Ihr SMS-Gateway: JETZT NEU unter: http://sms.city-map.de
System-Partner gesucht: http://www.franchise.city-map.de
--------------------------------------------------------
Handelsregister: AG Stade HRB 5811 - UstId: DE 213645563
--------------------------------------------------------


pgsql-general by date:

Previous
From: "Shridhar Daithankar"
Date:
Subject: Re: TESTING the DATABASE
Next
From: "Nigel J. Andrews"
Date:
Subject: Re: TESTING the DATABASE