Re: PL/PGSQL + inserts+updates+limit - Postgres 9.3

[Patrick B <patrickbakerbr@xxxxxxxxx>]

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?

If you guys please could give me the way to do that.. 

thanks

Patrick