in reply to Re^4: Returning multiple rows from pgplsql to DBI
in thread Returning multiple rows from pgplsql to DBI

I don't want to write select queries at the perl end

How will you call the plpgsql function in your module ?

poj
  • Comment on Re^5: Returning multiple rows from pgplsql to DBI

Replies are listed 'Best First'.
Re^6: Returning multiple rows from pgplsql to DBI
by anonymized user 468275 (Curate) on Jun 04, 2018 at 16:27 UTC
    There are various ways to call a function without using select, e.g. assignment and PERFORM. Although I may be constrained for the case of returning multiple values (although at some point I will still try to get around that)

    One world, one people