Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 9E9CA9FA489 for ; Tue, 26 Dec 2006 20:28:31 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 06209-04 for ; Tue, 26 Dec 2006 20:28:25 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.238]) by postgresql.org (Postfix) with ESMTP id BB04A9FA492 for ; Tue, 26 Dec 2006 20:28:25 -0400 (AST) Received: by wx-out-0506.google.com with SMTP id i28so4005185wxd for ; Tue, 26 Dec 2006 16:28:24 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:organization:user-agent:mime-version:to:subject:references:in-reply-to:content-type:content-transfer-encoding; b=bSZDVO8xJwuTOpH4Voz2STojOmgyNuF1A0FzxH8on3HkPmJ45iCHb6aQAYbf41nqktwBLwO0MO0EPgkNtdwlUMZLjkLmdb+rbGsoROX5LITnj6BCQGEbYsRVkXll13rkeiWEjqn0jWgEsyNt4Ohlp1d0UZyxSjk1k/oLDUvKA/4= Received: by 10.70.42.16 with SMTP id p16mr24537285wxp.1167179304533; Tue, 26 Dec 2006 16:28:24 -0800 (PST) Received: from ?192.168.1.9? ( [201.68.235.106]) by mx.google.com with ESMTP id i14sm20119430wxd.2006.12.26.16.28.22; Tue, 26 Dec 2006 16:28:24 -0800 (PST) Message-ID: <4591BE1B.4040601@gmail.com> Date: Tue, 26 Dec 2006 22:28:11 -0200 From: Iannsp Reply-To: iannsp@gmail.com Organization: iann tech User-Agent: Thunderbird 1.5.0.9 (Windows/20061207) MIME-Version: 1.0 To: Henrique P Machado , Guy Rouillier , pgsql-general@postgresql.org Subject: Re: NEED URGENT HELP.... References: <20061221074133.5B05A872DC@cal1-1.us4.outblaze.com> <4590629B.9070808@burntmail.com> <20061226115348.GB8412@svana.org> In-Reply-To: <20061226115348.GB8412@svana.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.345 tagged_above=0 required=5 tests=AWL, BAYES_40, SPF_PASS X-Spam-Level: X-Archive-Number: 200612/1469 X-Sequence-Number: 106407 Martijn van Oosterhout escreveu: > On Mon, Dec 25, 2006 at 08:52:52PM -0300, Henrique P Machado wrote: > >> WHERE (USER_ID = $1) AND (COMPANY_ID = $2) AND BOOK_NO IN ($3) >> >> Could'nt he use an array in this 3rd parameter? >> > > I think so, if it's written: > > AND BOOK_NO = ANY($3) > > Have a nice day, > I believe not because the aray have one another sintax, different of on simple data, but if you create one stored procedure you will be transform the data... If you sayd array to the data like '1,2,3' is another case, and I think you dont have problemns with this. ok. -- Ivo Nascimento Iann tech - Desenvolvendo soluções com performance e segurança http://www.ianntech.com.br