PostgreSQL-Ruby extention: calling Postgres functions

Ruby
1

Hi all,
I’m quite new to Ruby, and I have a question:
I’m using the Postgres-ruby extention to connect to my Postgres db
(require ‘postgres’ etc)
Now I need to call existing db functions but I don’t know how…
the function I want to call is

CREATE OR REPLACE FUNCTION sdr_new.pprocess_insert(pid_process integer,
pid_client integer, pid_entity integer, pppid integer, ppid_process
integer, pnotes character varying, pstatus integer, plast_update
timestamp without time zone, plogin_usuario character varying, pip
character varying)

as you can see it has a lot of parameter as well

Anyone could help me?

Cheers
Alessandro

2

as you can see it has a lot of parameter as well

Anyone could help me?

not sure how it is done with raw postgres driver (is it the exec()
method?) but if you use DBI (http://ruby-dbi.rubyforge.org/ ,
http://www.kitebird.com/articles/ruby-dbi.html) the .do() method should
do the trick.

The DBI in ruby is a standard method of interfacing to SQL databases (it
has drivers for several of them). Advantage is that the DBI interface is
pretty much same for all supported databases so in theory you could
switch the database (and use different database driver) but your code
would not change much…

Hope this helps,

Vlad