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

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Is it considered good practice to use stored procedures for most tasks?
Date: 2019-04-18 12:12:43
Message-ID: q99pjs$4fdm$1@blaine.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Pól Ua Laoínecháin 2019-04-18 20:15:23 Want records to be UNIQUE. When searching for dupes, stop on first matching record.
Previous Message Laszlo Forro 2019-04-18 11:12:39 Re: Is it considered good practice to use stored procedures for most tasks?