| From: | Jonathan Vanasco <postgres(at)2xlp(dot)com> |
|---|---|
| To: | pgsql general <pgsql-general(at)postgresql(dot)org> |
| Subject: | conditional joins and views |
| Date: | 2007-04-24 19:43:42 |
| Message-ID: | EA1E8567-C46D-4B05-8423-C1332104359D@2xlp.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Is it possible at all to use conditional joins in views?
ie:
select a.* , b.* from a inner join b ON ( (a.id = b.id) AND
(a.otherfield <> ?) )
I have a few 15-20 table joins that i'd like to push into views.
i've never wanted to push something with a conditional join into a
view before, so am at a loss on this being a possibility.
seeing little documentation on this, i'm thinking its not possible
and i'll have to use a function.
// Jonathan Vanasco
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - - - - -
| SyndiClick.com
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - - - - -
| 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
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - - - - -
| From | Date | Subject | |
|---|---|---|---|
| Next Message | William Garrison | 2007-04-24 19:50:00 | postgres on Windows: PAE and max memory |
| Previous Message | Jorge Godoy | 2007-04-24 19:36:52 | Re: Audit-trail engine: getting the application's layer user_id |