Re: sub-select - Mailing list pgsql-general

From Henrik Steffen
Subject Re: sub-select
Date
Msg-id 035301c31ae3$fd0caab0$9800a8c0@henrik
Whole thread Raw
In response to sub-select  ("Henrik Steffen" <steffen@city-map.de>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: sub-select
Next
From: Tom Lane
Date:
Subject: Re: psql and bytea