Postgres Pro
Downloads
Home   >   mailing lists

Re: PL/PGSQL + inserts+updates+limit - Postgres 9.3 - Mailing list pgsql-general

From David G. Johnston
Subject Re: PL/PGSQL + inserts+updates+limit - Postgres 9.3
Date
Msg-id CAKFQuwaU=N3JRuMkx80oUvNNyq4sH4+44m-bEqEGE_KP80J=Mg@mail.gmail.com
Whole thread Raw
In response to PL/PGSQL + inserts+updates+limit - Postgres 9.3  (Patrick Baker <patrickbakerbr@gmail.com>)
Responses Re: PL/PGSQL + inserts+updates+limit - Postgres 9.3  (Patrick Baker <patrickbakerbr@gmail.com>)
List pgsql-general
Tree view
On Wed, Jun 1, 2016 at 8:10 PM, Patrick Baker <patrickbakerbr@gmail.com> wrote:
Hi guys,

I need a function ( PL/PGSQL ) to perform a deletion of some BLOBS...


​[...]
​
When I will call the function: select function_1_name(5000) or select function_1_name(15000) will it respect the limited by the rows?

​I'd suggest you setup a test environment with some unimportant data on a non-production machine and try it yourself.
​
​​

David J.
​
 

pgsql-general by date:

Previous
From: Patrick Baker
Date:
Subject: PL/PGSQL + inserts+updates+limit - Postgres 9.3
Next
From: Patrick Baker
Date:
Subject: Re: PL/PGSQL + inserts+updates+limit - Postgres 9.3