pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
function parameters/output values
3+ messages / 2 participants
[nested] [flat]

* function parameters/output values
@ 2000-01-12 10:29  Thomas Leavitt <thomas.leavitt@clickrebates.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Thomas Leavitt @ 2000-01-12 10:29 UTC (permalink / raw)
  To: pgsql-sql

I would like to know if function parameters are used to pass output values
back to the function.

e.g.

create function func1(p1 varchar,p2 varchar OUTPUT, p3 varchar OUTPUT)
BEGIN
	SELECT p1 = t.foo1, p3 = t.foo2
	FROM test_table t
	WHERE foo3 = p1
END

DECLARE p2 varchar(50), p3 varchar(50)
CALL func1('abc',@p2 out,@p3 out)
PRINT @p2
PRINT @p3
--
Thomas Leavitt -- thomas.leavitt@clickrebates.com; 408-591-3342
Co-Founder/COO, ClickRebates.Com, Inc. (www.clickrebates.com)
Get Paid What You're Worth!

Sign up for our pre-launch guest list and refer your friends!

Or use our working prototype at www.clickrebates.org to "Surf for a Higher
Cause" (earn money for charity)




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

* Re: [SQL] function parameters/output values
@ 2000-01-12 23:29  Peter Eisentraut <peter_e@gmx.net>
  parent: Thomas Leavitt <thomas.leavitt@clickrebates.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Peter Eisentraut @ 2000-01-12 23:29 UTC (permalink / raw)
  To: Thomas Leavitt <thomas.leavitt@clickrebates.com>; +Cc: pgsql-sql

Chapter 4 of the programmer's guide.

On 2000-01-12, Thomas Leavitt mentioned:

> I would like to know if function parameters are used to pass output values
> back to the function.
> 
> e.g.
> 
> create function func1(p1 varchar,p2 varchar OUTPUT, p3 varchar OUTPUT)
> BEGIN
> 	SELECT p1 = t.foo1, p3 = t.foo2
> 	FROM test_table t
> 	WHERE foo3 = p1
> END
> 
> DECLARE p2 varchar(50), p3 varchar(50)
> CALL func1('abc',@p2 out,@p3 out)
> PRINT @p2
> PRINT @p3
> --
> Thomas Leavitt -- thomas.leavitt@clickrebates.com; 408-591-3342
> Co-Founder/COO, ClickRebates.Com, Inc. (www.clickrebates.com)
> Get Paid What You're Worth!
> 
> Sign up for our pre-launch guest list and refer your friends!
> 
> Or use our working prototype at www.clickrebates.org to "Surf for a Higher
> Cause" (earn money for charity)
> 
> 
> ************
> 
> 

-- 
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden





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

* RE: [SQL] function parameters/output values
@ 2000-01-13 00:40  Thomas Leavitt <thomas.leavitt@clickrebates.com>
  parent: Peter Eisentraut <peter_e@gmx.net>
  0 siblings, 0 replies; 3+ messages in thread

From: Thomas Leavitt @ 2000-01-13 00:40 UTC (permalink / raw)
  To: Peter Eisentraut <peter_e@gmx.net>; +Cc: pgsql-sql

Peter,

Thanks for responding!

We looked at Chapter 4, and could not conclusively determine whether this
was the case. Can you point us to a specific page, paragraph, etc.? Can you
point us to some code examples (outside of the documentation)?

(Why isn't this in the FAQ... seems to be a very common question... and yet
almost impossible to conclusively determine by searching through the mailing
lists or documentation...)

Thomas

--
Thomas Leavitt -- thomas.leavitt@clickrebates.com; 408-591-3342
Co-Founder/COO, ClickRebates.Com, Inc. (www.clickrebates.com)
Get Paid What You're Worth!

Sign up for our pre-launch guest list and refer your friends!

Or use our working prototype at www.clickrebates.org to "Surf for a Higher
Cause" (earn money for charity)


> -----Original Message-----
> From: owner-pgsql-sql@postgreSQL.org
> [mailto:owner-pgsql-sql@postgreSQL.org]On Behalf Of Peter Eisentraut
> Sent: Wednesday, January 12, 2000 3:30 PM
> To: Thomas Leavitt
> Cc: pgsql-sql@postgreSQL.org
> Subject: Re: [SQL] function parameters/output values
>
>
> Chapter 4 of the programmer's guide.
>
> On 2000-01-12, Thomas Leavitt mentioned:
>
> > I would like to know if function parameters are used to pass
> output values
> > back to the function.
> >
> > e.g.
> >
> > create function func1(p1 varchar,p2 varchar OUTPUT, p3 varchar OUTPUT)
> > BEGIN
> > 	SELECT p1 = t.foo1, p3 = t.foo2
> > 	FROM test_table t
> > 	WHERE foo3 = p1
> > END
> >
> > DECLARE p2 varchar(50), p3 varchar(50)
> > CALL func1('abc',@p2 out,@p3 out)
> > PRINT @p2
> > PRINT @p3
> > --
> > Thomas Leavitt -- thomas.leavitt@clickrebates.com; 408-591-3342
> > Co-Founder/COO, ClickRebates.Com, Inc. (www.clickrebates.com)
> > Get Paid What You're Worth!
> >
> > Sign up for our pre-launch guest list and refer your friends!
> >
> > Or use our working prototype at www.clickrebates.org to "Surf
> for a Higher
> > Cause" (earn money for charity)
> >
> >
> > ************
> >
> >
>
> --
> Peter Eisentraut                  Sernanders väg 10:115
> peter_e@gmx.net                   75262 Uppsala
> http://yi.org/peter-e/            Sweden
>
>
>
> ************
>
>




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


end of thread, other threads:[~2000-01-13 00:40 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-01-12 10:29 function parameters/output values Thomas Leavitt <thomas.leavitt@clickrebates.com>
2000-01-12 23:29 ` Peter Eisentraut <peter_e@gmx.net>
2000-01-13 00:40   ` Thomas Leavitt <thomas.leavitt@clickrebates.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