Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 7D8452E003D for ; Tue, 26 Feb 2008 12:36:56 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 61765-07 for ; Tue, 26 Feb 2008 12:36:53 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from smtpauth.rollernet.us (smtpauth.rollernet.us [208.11.75.5]) by postgresql.org (Postfix) with ESMTP id 4E8B02E0032 for ; Tue, 26 Feb 2008 12:36:53 -0400 (AST) Received: from smtpauth.rollernet.us (localhost.localdomain [127.0.0.1]) by smtpauth.rollernet.us (Postfix) with ESMTP id 2AB71594038; Tue, 26 Feb 2008 08:36:50 -0800 (PST) Received: from iron.denterprises.org (ool-4350518d.dyn.optonline.net [67.80.81.141]) by smtpauth.rollernet.us (Postfix) with ESMTP; Tue, 26 Feb 2008 08:36:49 -0800 (PST) Received: from lamp.iron.denterprises.org (lamp.iron.denterprises.org [192.168.171.84]) by iron.denterprises.org (Postfix) with ESMTP id A280A1676AE; Tue, 26 Feb 2008 11:36:48 -0500 (EST) Message-ID: <47C44023.4080007@denterprises.org> Date: Tue, 26 Feb 2008 11:36:51 -0500 From: Colin Wetherbee User-Agent: Thunderbird 2.0.0.9 (Macintosh/20071031) MIME-Version: 1.0 To: =?ISO-8859-1?Q?Professor_Fl=E1vio_Brito?= CC: pgsql-sql@postgresql.org Subject: Re: Function returns error (view) References: <6a5e3a6f0802260832k9c1375ap632f8adad0740fa2@mail.gmail.com> In-Reply-To: <6a5e3a6f0802260832k9c1375ap632f8adad0740fa2@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Rollernet-Abuse: Processed by Roller Network Mail Services. Contact abuse@rollernet.us to report violations. Abuse policy: http://rollernet.us/abuse.php X-Rollernet-Submit: Submit ID 3206.47c44021.ed8c4.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/207 X-Sequence-Number: 30298 Professor Flávio Brito wrote: > When I Test my view I receive > > SELECT seach_password('user_login_foo') [...] > ERROR: column "user_login_foo" does not exist > SQL state: 42703 > Context: PL/pgSQL function "search_password" line 14 at for over execute > statement seach_password and search_password are different. Perhaps you have two functions with similar names, and one is broken? Colin