X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9F54AD9FEF for ; Wed, 19 Oct 2005 02:54:25 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 40676-01 for ; Wed, 19 Oct 2005 05:54:23 +0000 (GMT) Received: from web35212.mail.mud.yahoo.com (web35212.mail.mud.yahoo.com [66.163.179.91]) by svr1.postgresql.org (Postfix) with SMTP id 6E195D9FD0 for ; Wed, 19 Oct 2005 02:54:23 -0300 (ADT) Received: (qmail 57879 invoked by uid 60001); 19 Oct 2005 05:54:23 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=xYtdM+cUtgdh7cFSPnjsFY9FyocpLZBqpsyf42nWkRns0GvgprTN471mOeuDDsYGe+PhOlf5SRGf4i3aJBSrIGXCUuUE/O7LXk075iJbwxYIIeezJ/FHwXVSdeM2lZyymUfaJNRJ1zm88OBjhyUqaiuM210+E+T+U3mqgbsZmfU= ; Message-ID: <20051019055423.57877.qmail@web35212.mail.mud.yahoo.com> Received: from [70.104.144.58] by web35212.mail.mud.yahoo.com via HTTP; Tue, 18 Oct 2005 22:54:23 PDT Date: Tue, 18 Oct 2005 22:54:23 -0700 (PDT) From: Matthew Peter Subject: Re: problems with array To: Michael Fuhr Cc: pgsql-sql@postgresql.org In-Reply-To: <20051019033544.GA66012@winnie.fuhr.org> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.266 required=5 tests=[AWL=-0.108, DNS_FROM_RFC_ABUSE=0.374] X-Spam-Level: X-Archive-Number: 200510/211 X-Sequence-Number: 23064 Ya, I didn't test it. The error message was expecting an integer not an array, so coverting it to a list crossed my mind 'assuming' the subselect 'could' return a string of integers for the IN clause. Oh well. I'm glad there's people like you test it. --- Michael Fuhr wrote: > I doubt it, considering that it doesn't work :-( __________________________________ Yahoo! Music Unlimited Access over 1 million songs. Try it free. http://music.yahoo.com/unlimited/