Search Postgresql Archives

Re: Query performance issue

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tue, Oct 22, 2024 at 1:01 PM Ron Johnson <ronljohnsonjr@xxxxxxxxx> wrote:
On Tue, Oct 22, 2024 at 3:02 PM Greg Sabino Mullane <htamfids@xxxxxxxxx> wrote:
[snip] 
* Don't use the "FROM table1, table2, table3" syntax but use "FROM table1 JOIN table2 ON (...) JOIN table3 ON (...)

Why?


Readability is improved when done correctly; and you need to know it for outer joins anyway, so consistency.

David J.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux