Stored procedures - how to start - Mailing list pgsql-general

From Andreas Tille
Subject Stored procedures - how to start
Date
Msg-id Pine.LNX.4.21.0008111528170.25058-100000@wr-linux02.rki.de
Whole thread Raw
List 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.



pgsql-general by date:

Previous
From: Andreas Tille
Date:
Subject: pg_dump and restore -- solved and urgent warning
Next
From: "Eric Spaulding"
Date:
Subject: