On Jan 18, 2007, at 11:57 PM, Neal Clark wrote:
> hey Pal,
>
> I did what you recommended below, and I wrote some stored procedures
> to join the tables and get exactly what I want back. So far its
> working out great!
>
> I felt a little bit guilty posting my questions to the rose::db list.
> I've joined some other database lists now so I'll try to stay on
> topic if I post to rose::db again. Either way, thanks for taking the
> time to help.
stored procedures might be overdoing it. they're great for inserts
and manipulation -- but it sounds like you just want a VIEW
VIEWs are great, because they work out essentially as tables -- so
you can create ROSE DB objects for selecting (though not inserting)
you should read the o'reilly book Practical PostgreSQL
its free online here:
http://www.faqs.org/docs/ppbook/book1.htm
that should really set you on the right track.
good luck!
// Jonathan Vanasco
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - -
| FindMeOn.com - The cure for Multiple Web Personality Disorder
| Web Identity Management and 3D Social Networking
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - -
| RoadSound.com - Tools For Bands, Stuff For Fans
| Collaborative Online Management And Syndication Tools
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - -
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Rose-db-object mailing list
Rose-db-object@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rose-db-object
