pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Postgres 7.4 function
2+ messages / 2 participants
[nested] [flat]

* Postgres 7.4 function
@ 2007-08-29 18:41 Radhika Sambamurti <radhika@88thstreet.com>
  2007-08-29 19:12 ` Re: Postgres 7.4 function Scott Marlowe <scott.marlowe@gmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Radhika Sambamurti @ 2007-08-29 18:41 UTC (permalink / raw)
  To: pgsql-sql

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




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Postgres 7.4 function
  2007-08-29 18:41 Postgres 7.4 function Radhika Sambamurti <radhika@88thstreet.com>
@ 2007-08-29 19:12 ` Scott Marlowe <scott.marlowe@gmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Scott Marlowe @ 2007-08-29 19:12 UTC (permalink / raw)
  To: radhika@88thstreet.com; +Cc: pgsql-sql

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.  :)



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2007-08-29 19:12 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-08-29 18:41 Postgres 7.4 function Radhika Sambamurti <radhika@88thstreet.com>
2007-08-29 19:12 ` Scott Marlowe <scott.marlowe@gmail.com>

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