Ruby tutorial for how to write stored procedures for PostgreSQL?

Question

I have heard that one in PostgreSQL can write stored procedures in Ruby.

But I haven't been able to find more information about it teaching one how to actually do it.

Could someone recommend good sources for that.

Thanks

Sadly, it appears that the PL/Ruby project is no longer being maintained. — Alex D
– Alex D, Commented Apr 7, 2013 at 20:46

Daniel O'Hara · Accepted Answer · 2010-08-01 02:42:25Z

7

Obviously, you need to install PL/Ruby. After that, you can write:

CREATE FUNCTION ruby_max(int4, int4) RETURNS int4 AS '
    if args[0].to_i > args[1].to_i
        return args[0]
    else
        return args[1]
    end
' LANGUAGE 'plruby';

Check its GitHub repository for installation instructions.

answered Aug 1, 2010 at 2:42

Daniel O'Hara

13.5k3 gold badges48 silver badges70 bronze badges

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

1 Comment

Daniel O'Hara Over a year ago

Some information regarding installation: stackoverflow.com/questions/617600/…

Frank Heikens · Accepted Answer · 2010-08-01 09:03:09Z

2

Check this website: http://moulon.inra.fr/ruby/plruby.html , it has some nice examples.

answered Aug 1, 2010 at 9:03

Frank Heikens

129k26 gold badges157 silver badges153 bronze badges

1 Comment

Aaron Greenlee Over a year ago

The site referenced above appears to have gone dark.

Collectives™ on Stack Overflow

Ruby tutorial for how to write stored procedures for PostgreSQL?

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related