From: Scott Marlowe <scott.marlowe@gmail.com>
To: radhika@88thstreet.com
Cc: pgsql-sql@postgresql.org
Subject: Re: Postgres 7.4 function
Date: Wed, 29 Aug 2007 14:12:25 -0500
Message-ID: <dcc563d10708291212t2935c46es7fc0ce39666497cd@mail.gmail.com> (raw)
In-Reply-To: <1129.63.118.86.10.1188412883.squirrel@www.88thstreet.com>
References: <1129.63.118.86.10.1188412883.squirrel@www.88thstreet.com>
On 8/29/07, Radhika Sambamurti <radhika@88thstreet.com> 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. :)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: scott.marlowe@gmail.com, radhika@88thstreet.com
Subject: Re: Postgres 7.4 function
In-Reply-To: <dcc563d10708291212t2935c46es7fc0ce39666497cd@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox