[SQL] Postgres 7.4 function

[Radhika Sambamurti]

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
---


---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org

Re: [SQL] Postgres 7.4 function

[Scott Marlowe]

On 8/29/07, Radhika Sambamurti <[EMAIL PROTECTED]> 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.  :)

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster