On 06/06/2016 09:01 PM, Patrick B wrote:
Ok so guys....CREATE or REPLACE FUNCTION function_data_1() RETURNS SETOF bigint AS $$ declare row record; BEGIN [...] FOR row IN EXECUTE ' SELECT t1.file_id, t1.path, t1.account_id FROM table1 t1 JOIN table3 t3 ON t3.file_Id = t1.file_id WHERE t3.migrated = 0 AND *t3.account_id = 1112* ORDER BY 1 LIMIT 30 ' [...] How can I make the function works with account_id? *Example: select function_data_1(1112)* and then it will do all the work just for that specific account_id?
https://www.postgresql.org/docs/9.5/static/plpgsql-declarations.html#PLPGSQL-DECLARATION-PARAMETERS
If you guys please could give me the way to do that.. thanks Patrick
-- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
