Re: Is it considered good practice to use stored procedures for most tasks?

Laurenz Albe <[email protected]> Thu, 18 Apr 2019 10:36:13 +0200
Newsgroups gmane.comp.db.postgresql.novice
Organization Cybertec
Message-ID <[email protected]>
Gaetano Mendola wrote:
> For sure do not allow your application to touch directly tables, use views and sp,
> lately I'm abandoning views for table functions.

As far as I know, a table function result is materialized on the server,
and you have to wait for the query to finish before you can retrieve the
first row.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com