Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

Re: Custom SQL in DBIx::Class (or how to use PgSQL fulltext search from Perl)

by Mutant (Priest)
on May 07, 2009 at 11:29 UTC ( #762572=note: print w/ replies, xml ) Need Help??


in reply to Custom SQL in DBIx::Class (or how to use PgSQL fulltext search from Perl)

Not sure on the SQL::Abstract approach (you could try the DBIC mailing list, or the channel on irc.perl.org), but I've found one way around this when SQL::Abstract won't cut the mustard is to create a ResultSet class, get the DBI object, and manually execute a query.

The main downside is you don't get back objects (altho I think it might be possible to construct them). SQL abstraction is nice, but not always the best approach.


Comment on Re: Custom SQL in DBIx::Class (or how to use PgSQL fulltext search from Perl)

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://762572]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (8)
As of 2015-07-29 03:12 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (260 votes), past polls