Postgres Pro
Downloads
Home   >   mailing lists

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

From Thomas Kellerer
Subject Re: Is it considered good practice to use stored procedures for mosttasks?
Date
Msg-id q99pjs$4fdm$1@blaine.gmane.org
Whole thread Raw
In response to Re: Is it considered good practice to use stored procedures formost tasks?  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-novice
Tree view 
Laurenz Albe schrieb am 18.04.2019 um 10:36:
>> 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.

Is that true for SQL functions as well? 

Especially when they are inlined, I can't imagine they are handled differently than a regular query. 

Thomas

pgsql-novice by date:

Previous
From: Laszlo Forro
Date:
Subject: Re: Is it considered good practice to use stored procedures for most tasks?
Next
From: Pól Ua Laoínecháin
Date:
Subject: Want records to be UNIQUE. When searching for dupes, stop on firstmatching record.