pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedReturning records from a function
2+ messages / 2 participants
[nested] [flat]
* Returning records from a function
@ 2003-02-02 07:20 John C <oogly@rogers.com>
0 siblings, 1 reply; 2+ messages in thread
From: oogly@rogers.com @ 2003-02-02 07:20 UTC (permalink / raw)
To: pgsql-sql
I've spent the last few hours trying to come up with a function that
at the most basic returns the result of a SELECT * FROM <table>.
This is easy to do in something like MSSQL or Oracle. For example in
MSSQL i can do something like:
CREATE PROCEDURE proc_name AS
BEGIN
SELECT * FROM sometable
END
How do I do something like that with a Postgresql function/stored
procedure? All I really want to know is how to by using a function how
can I return the results of a SELECT * query!?
The end result of the query I need is more complicated, but I can't
even get something that easy to work. Are functions unable to return
result sets?? All of the examples i've seen always return a single
value, like an int. That doesn't do me any good.
I want to use a few stored procedures to create some faster processing
for some queries that involve 3-4 tables plus require some input
parameters, and return a result set.
Any help would be appriciated. I've just recently started using
PostgreSQL and I'm very impressed! I'm sure I'm jsut overlooking
something easy, but for the life of me i just cant figure it out.
Thanks,
John
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Returning records from a function
@ 2003-02-06 18:57 Lex Berezhny <LBerezhny@DevIS.com>
parent: John C <oogly@rogers.com>
0 siblings, 0 replies; 2+ messages in thread
From: Lex Berezhny @ 2003-02-06 18:57 UTC (permalink / raw)
To: John C <oogly@rogers.com>; +Cc: pgsql-sql
Hi John,
It is in the documentation ;-)
http://developer.postgresql.org/docs/postgres/plpgsql-control-structures.html
Also, this tutorial might be helpful:
http://techdocs.postgresql.org/guides/SetReturningFunctions
good luck,
- lex
On Sun, 2003-02-02 at 02:20, John C wrote:
> I've spent the last few hours trying to come up with a function that
> at the most basic returns the result of a SELECT * FROM <table>.
>
> This is easy to do in something like MSSQL or Oracle. For example in
> MSSQL i can do something like:
>
> CREATE PROCEDURE proc_name AS
>
> BEGIN
> SELECT * FROM sometable
> END
>
>
> How do I do something like that with a Postgresql function/stored
> procedure? All I really want to know is how to by using a function how
> can I return the results of a SELECT * query!?
>
> The end result of the query I need is more complicated, but I can't
> even get something that easy to work. Are functions unable to return
> result sets?? All of the examples i've seen always return a single
> value, like an int. That doesn't do me any good.
>
> I want to use a few stored procedures to create some faster processing
> for some queries that involve 3-4 tables plus require some input
> parameters, and return a result set.
>
> Any help would be appriciated. I've just recently started using
> PostgreSQL and I'm very impressed! I'm sure I'm jsut overlooking
> something easy, but for the life of me i just cant figure it out.
>
> Thanks,
> John
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2003-02-06 18:57 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-02-02 07:20 Returning records from a function John C <oogly@rogers.com>
2003-02-06 18:57 ` Lex Berezhny <LBerezhny@DevIS.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