Re: sub-select
От | Henrik Steffen |
---|---|
Тема | Re: sub-select |
Дата | |
Msg-id | 035301c31ae3$fd0caab0$9800a8c0@henrik обсуждение исходный текст |
Ответ на | sub-select ("Henrik Steffen" <steffen@city-map.de>) |
Список | pgsql-general |
thanks tom stupid me, -- 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 -------------------------------------------------------- ----- Original Message ----- From: "Tom Lane" <tgl@sss.pgh.pa.us> To: "Henrik Steffen" <steffen@city-map.de> Cc: "pgsql" <pgsql-general@postgresql.org> Sent: Thursday, May 15, 2003 3:03 PM Subject: Re: [GENERAL] sub-select > "Henrik Steffen" <steffen@city-map.de> writes: > > 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)... > > What's the datatype of foobar? I'm betting it's char(n), and > you're losing in the second case because of (lack of) trailing > spaces. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
В списке pgsql-general по дате отправления: