Using Laravel DB object to run postgresql functions with input parameters

Question

I have some postgresql functions that I run in the form:

SELECT * FROM pgfunction(1,2,3);

This enables me to filter / order / group the results:

SELECT * FROM pgfunction(1,2,3) WHERE value > 10;

How could I pass the parameters to the postgresql function in laravel using prepared statements in order to filter the results in laravel. Example:

DB::table('pgfunction',array(1,2,3))->where('value','>','10');

Is this possible?

fideloper · Accepted Answer · 2013-09-12 15:47:30Z

2

DB::raw will create a raw SQL string, but not use it as a query. You may need to use a DB::select() to run a "raw sql" query.

$fnc = sprintf("pgfunction(%s)", implode(',', array(1,2,3));

DB::select()->from(DB::raw($fnc))->where('value', '>', 10);

Note: This is untested on my end. Hope it helps. See the docs on using Raw Expressions for more information on using that.

answered Sep 12, 2013 at 15:47

fideloper

12.3k1 gold badge43 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Joyce Over a year ago

Yes, I have mixed "DB::RAW" and "DB::table". I have fixed this typo in the question. The idea was to use this function as a table exactly as postgresql does.

Collectives™ on Stack Overflow

Using Laravel DB object to run postgresql functions with input parameters

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related