Re: [Catalyst] Can PL/pgSQL be called from DBIx::Class Interface?

[Dennis Daupert]

On Tue, 2 Jan 2007 15:58:39 Matt S Trout wrote:

we discussed it last week and a solution was posted.

Thanks for that info, Matt, I grabbed the DBIx-Class archive
for December, and found the post.

Please don't ask DBIx::Class questions on the Catalyst list

ok

/dennis
___
List: Catalyst@lists.rawmode.org
Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@lists.rawmode.org/
Dev site: http://dev.catalyst.perl.org/

[Catalyst] Can PL/pgSQL be called from DBIx::Class Interface?

[Dennis Daupert]

I'm asking here instead of DBIx::Class newsgroup cuz I seldom have db questions 
(and most of what goes on there is over my head anyway :)

I'm following an O'reilly article on writing PostgreSQL Functions with PL/pgSQL:

http://www.onlamp.com/lpt/a/6573

Most of my Catalyst/db acitivity is through DBIx::Class, but seems like some 
interactions could use the db's native programming features to great advantage. 
One of the functions to add tags would be called like this:

SELECT entry_coll_tag_add(24, '{223,12,52}');

Is there a 'conduit' in the ORM's interface to send such selects to?

/dennis


___
List: Catalyst@lists.rawmode.org
Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@lists.rawmode.org/
Dev site: http://dev.catalyst.perl.org/