pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Radhika Sambamurti <radhika@88thstreet.com>
To: pgsql-sql@postgresql.org
Subject: Postgres 7.4 function
Date: Wed, 29 Aug 2007 14:41:23 -0400 (EDT)
Message-ID: <1129.63.118.86.10.1188412883.squirrel@www.88thstreet.com> (raw)

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




view thread (2+ messages)  latest in thread

Message-ID: <1129.63.118.86.10.1188412883.squirrel@www.88thstreet.com>
Permalink:  ../1129.63.118.86.10.1188412883.squirrel@www.88thstreet.com/
Also on:    postgresql.org/message-id/1129.63.118.86.10.1188412883.squirrel@www.88thstreet.com

 · 

reply

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: radhika@88thstreet.com
  Subject: Re: Postgres 7.4 function
  In-Reply-To: <1129.63.118.86.10.1188412883.squirrel@www.88thstreet.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