Question 114542 in PostgreSQL Question posted in
The official documentation can be found here.

Using a PostgreSQL function inside a loop

Suppose I have a PostgreSQL function that takes 2 parameters: id (INT), email (TEXT) and can be called like this:

SELECT * FROM my_function(101, '[email protected]')

I want to run a SELECT query from a table that would return multiple id’s:

SELECT id FROM mytable

  | id   |
--+------+
  | 101  |
--+------+
  | 102  |
--+------+
  | 103  |

How would I loop through and plug each of the returned id’s into my function in a query. FOr this example just assume the default email is alwasy "[email protected]"

Tags:

2

Answers


  1. 0

    I’m on mobile so I can’t test it, but I think maybe this will work.

    SELECT * FROM (select my_function(id, '[email protected]') from mytable);
    Login or Signup to reply.
  2. 0

    You can use a cross join:

    SELECT * 
FROM my_table mt 
  cross join lateral my_function(mt.id, '[email protected]') as mf
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search