On Monday, May 16, 2016 at 11:32:11 AM UTC-7, Scott Bellware wrote:
>
> Thanks, Jeremy.
>
> Unfortunately, I just don't understand what to do with that information to
> close the loop on where I am and where I need to be and what to understand.
>
> Sorry for my denseness.
>
> I don't want to take too much of your time on beginner questions, but I
> thought I'd offer a quick example of what I'm struggling with.
>
> Specifically, I don't know how to call a Postgres function, or access its
> results.
>
> Here's the simple Postgres function I'm using to figure it out:
>
> CREATE OR REPLACE FUNCTION some_func(some_arg int)
> RETURNS int
> AS $$
> BEGIN
> RETURN some_arg + some_arg;
> END;
> $$ LANGUAGE plpgsql;
>
> Calling this function with an int, eg: 11, will return the double of the
> int, eg: 22.
>
> Given that I already have an active connection, is there a way that I can
> invoke this function using Sequel, and then get the int value that is
> returned?
>
Yes. The easiest way is using a virtual row:
DB.get{some_func(11)}
Thanks,
Jeremy
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sequel-talk.
For more options, visit https://groups.google.com/d/optout.
