Re^4: Returning multiple rows from pgplsql to DBI


Clear questions and runnable code get the best and fastest answer
	PerlMonks

Re^4: Returning multiple rows from pgplsql to DBI

by anonymized user 468275 (Curate)

on May 31, 2018 at 22:31 UTC ( [id://1215587]=note: print w/replies, xml )

Need Help??

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

If it works, wouldn't it be the same as RETURN QUERY SELECT ...? At some point I also have to restrict access to function calls and SELECT etc. will become forbidden for security reasons.

One world, one people

Comment on Re^4: Returning multiple rows from pgplsql to DBI

Replies are listed 'Best First'.
Re^5: Returning multiple rows from pgplsql to DBI by poj (Abbot) on Jun 01, 2018 at 09:33 UTC
I don't want to write select queries at the perl end How will you call the plpgsql function in your module ? poj	[reply]
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	[reply]

In Section Seekers of Perl Wisdom

Log In^?

Domain Nodelet^?

www.com | www.net | www.org

Node Status^?

node history
Node Type: note [id://1215587]
help

Chatterbox^?

How do I use this? • Last hour • Other CB clients

Other Users^?

Others rifling through the Monastery: (4)

As of 2024-04-19 22:32 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Today I Learned

Voting Booth^?

No recent polls found