Stored procedures - how to start

From: Andreas Tille <tillea(at)rki(dot)de>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Stored procedures - how to start
Date: 2000-08-11 13:33:49
Message-ID: Pine.LNX.4.21.0008111528170.25058-100000@wr-linux02.rki.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I really like the concept of PostgeSQLs functions. But what do
I have to do if I like to get a whole table, i.e. how to
perform a

SELECT * FROM <table> ;

in a stored procedure. I wrote servlet code with many stored
procedures for MS SQL server and now wondering, how to port those
things but failed to find something in the docs. Could someone
give just a short example (may be how to do the SELECT above)
or give a hint to docs.

Kind regards

Andreas.

Browse pgsql-general by date

  From Date Subject
Next Message Eric Spaulding 2000-08-11 14:16:08
Previous Message Andreas Tille 2000-08-11 13:07:46 pg_dump and restore -- solved and urgent warning