[SQL] Postgres 7.4 function

2007-08-29 Thread 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 tabl

Re: [SQL] Postgres 7.4 function

2007-08-29 Thread 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. > >