Postgres Pro
Downloads
Home   >   mailing lists

Re: Is it considered good practice to use stored procedures formost tasks? - Mailing list pgsql-novice

From Laurenz Albe
Subject Re: Is it considered good practice to use stored procedures formost tasks?
Date
Msg-id 0fe0d50a25af3604b680905901c7c3754c32b1f4.camel@cybertec.at
Whole thread Raw
In response to Re: Is it considered good practice to use stored procedures for most tasks?  (Gaetano Mendola <mendola@gmail.com>)
Responses Re: Is it considered good practice to use stored procedures for most tasks?
Re: Is it considered good practice to use stored procedures for mosttasks?
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: Steve Horn
Date:
Subject: Re: Is it considered good practice to use stored procedures for most tasks?
Next
From: Gaetano Mendola
Date:
Subject: Re: Is it considered good practice to use stored procedures for most tasks?