Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 81FF19FA654 for ; Wed, 29 Aug 2007 16:04:49 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 05745-02-3 for ; Wed, 29 Aug 2007 16:04:44 -0300 (ADT) X-Greylist: delayed 00:12:26.400729 by SQLgrey-1.7.5 Received: from rootabega.88thstreet.com (dsl254-071-237.nyc1.dsl.speakeasy.net [216.254.71.237]) by postgresql.org (Postfix) with ESMTP id BD2999FA677 for ; Wed, 29 Aug 2007 15:53:51 -0300 (ADT) Received: from www.88thstreet.com (localhost [IPv6:::1]) by rootabega.88thstreet.com (8.13.3/8.13.3) with ESMTP id l7TIfNlL007135 for ; Wed, 29 Aug 2007 14:41:23 -0400 (EDT) Received: from 63.118.86.10 (SquirrelMail authenticated user radhika) by www.88thstreet.com with HTTP; Wed, 29 Aug 2007 14:41:23 -0400 (EDT) Message-ID: <1129.63.118.86.10.1188412883.squirrel@www.88thstreet.com> Date: Wed, 29 Aug 2007 14:41:23 -0400 (EDT) Subject: Postgres 7.4 function From: "Radhika Sambamurti" To: pgsql-sql@postgresql.org Reply-To: radhika@88thstreet.com User-Agent: SquirrelMail/1.4.5 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/251 X-Sequence-Number: 29189 Hi, I am using a function in postgres 7.4 that returns an integer. I modified my store procedure (same function and parameters) to point to another table, and return an int. But now I am not getting the correct answer only 0. I verified that the column I am returning is int in both the first table and hte modified table. I even tried returning a varchar (the native type for postgres libpq). Still no luck. Any ideas? Thanks Radhika -- It is all a matter of perspective. You choose your view by choosing where to stand. Larry Wall ---