Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id DA9079FB79C for ; Wed, 29 Aug 2007 16:12:36 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 69887-01-4 for ; Wed, 29 Aug 2007 16:12:30 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.236]) by postgresql.org (Postfix) with ESMTP id D61F69FB77E for ; Wed, 29 Aug 2007 16:12:27 -0300 (ADT) Received: by nz-out-0506.google.com with SMTP id l8so216416nzf for ; Wed, 29 Aug 2007 12:12:26 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=mmJcAAK24wibaWGsvQrHi2XzL83uTHxwvbEH+nDVUahOJdXvvyjSdm/7fPTHOYPXVsLQIqfEzUUrmsRqwg7VMAJla0YBIWSCbRRdQQaCrvrue2Obz0pm8uyDRqlhhvAui8Wpc/FVn306WFXwI/xI2ciQjNAi0GfPiSDi/EufXQ4= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=MVO49CzF68he5daRH/dxD1zUKonlFybaTvFa+GAwTAE4i9CV/qZXUfAeBKfgx0oinfneKEmSl536Cb/HvLCijHLCxB3tVezR7CHEwRMx+HZsbCzERNfEoVD5KILpnPsgplKO7HA+bRxixyuEsoaoDKRpfUJsI8vNL3XCVl4Zu/s= Received: by 10.140.141.15 with SMTP id o15mr513267rvd.1188414745935; Wed, 29 Aug 2007 12:12:25 -0700 (PDT) Received: by 10.141.159.11 with HTTP; Wed, 29 Aug 2007 12:12:25 -0700 (PDT) Message-ID: Date: Wed, 29 Aug 2007 14:12:25 -0500 From: "Scott Marlowe" To: radhika@88thstreet.com Subject: Re: Postgres 7.4 function Cc: pgsql-sql@postgresql.org In-Reply-To: <1129.63.118.86.10.1188412883.squirrel@www.88thstreet.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <1129.63.118.86.10.1188412883.squirrel@www.88thstreet.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/252 X-Sequence-Number: 29190 On 8/29/07, Radhika Sambamurti wrote: > 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. Can you make a small example case of what you're doing that will produce the error? Warning, I don't have a 7.4 instance running anymore, but someone else might. :)