| From: | culley harrelson <culley(at)fastmail(dot)fm> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | explicit joins vs implicit joins |
| Date: | 2003-06-19 07:52:26 |
| Message-ID: | bcrpra$fkp$1@main.gmane.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Once upon a time when I taught myself sql I learned the explicit join
syntax-- I have never really used the where clause to create joins.
With this style of sql I have been building/maintaining a
postgresql-centric web application since postgresql 7.0 and now I am
learning that by writing my sql in this fashion I am constricting the
planner. After reading this:
http://marc.theaimsgroup.com/?l=postgresql-general&m=105551123915183&w=2
I am wondering if things are going to change in 7.4? Or should I switch
to placing joins in the where clause when I can? I don't want to have
to worry about my join order-- I would prefer to let the planner do its
thing 95% of the time.
culley
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2003-06-19 08:35:22 | Re: Can inherited tables help in this case? |
| Previous Message | Ron Johnson | 2003-06-19 07:43:12 | Re: A creepy story about dates. How to prevent it? |