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.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
