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
