Sixtease has asked for the wisdom of the Perl Monks concerning the following question:
Hail friends!
I'm working my way through with DBIC in Catalyst and I found myself needing to simply call a postgres function from a template (or from the controller if must be).
I have an enum type in the database and would like to generate <option>s for them within a <select>.
I'd like to see the result of the postgres function enum_range.
I was searching for a simple mechanism that would let me enter arbitrary SQL (not just the condition part), so I could write SELECT enum_range(typename);. But I have failed to find one.
Do you have any advice?
use strict; use warnings; print "Just Another Perl Hacker\n";
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: SQL function from DBIC
by CountZero (Bishop) on Dec 07, 2008 at 16:52 UTC | |
by Sixtease (Friar) on Dec 07, 2008 at 18:59 UTC | |
Re: SQL function from DBIC
by Corion (Patriarch) on Dec 07, 2008 at 15:23 UTC | |
by zby (Vicar) on Dec 08, 2008 at 00:29 UTC | |
Re: SQL function from DBIC
by f00li5h (Chaplain) on Dec 07, 2008 at 16:32 UTC | |
Re: SQL function from DBIC
by davidrw (Prior) on Dec 07, 2008 at 15:30 UTC | |
by jasonk (Parson) on Dec 07, 2008 at 23:22 UTC | |
Re: SQL function from DBIC
by Sixtease (Friar) on Dec 07, 2008 at 15:59 UTC |
Back to
Seekers of Perl Wisdom