July 17th, 2003, 07:37 AM
Possible to make a crossed reference query?
I need to use a crossed reference query, just like in ms access. Is it possible to do that? How? Is there a tutorial somewhere?
Is there a workaround on that?
Thanks to all.
July 18th, 2003, 04:41 PM
July 18th, 2003, 04:54 PM
It's crosstab actually
You're right. Crosstab is the right word for what i'm looking for. I believe you're right about crosstab being more likely to be handled on the cliente side.
Even so, there's a function called crosstab() inside the postgres installed directories developes by Joe Conway that handles that. I couldn't get that working yet.
Despite that, i'm already considering that to be handled by my application rather than by the server. I'm now looking for a java class that does that.
I only thought this would be a topic discussed a little more deeply, once it's a very useful feature. I believed i would find more articles and stuff on this area over the internet.
Thanks a lot.