[GENERAL] Difference between ON and WHERE in JOINs

I'm looking for an article that explains the difference between these constructs IN POSTGRESQL (the rules seem to differ from one DB to another) : SELECT A.* FROM A JOIN B ON a.id=b.id AND A.somefield='somevalue' and SELECT A.* FROM A JOIN B ON a.id=b.id WHERE A.somefield='somevalue' I have

Re: [GENERAL] Difference between ON and WHERE in JOINs

Le 19/09/2012 02:47, David Johnston a écrit : > There is no difference in your example. Conceptually though I > suggest using only table-table conditions in an ON clause and placing > any table-value conditions into the where. This is how I use it usually. > The main time you get differences is

Re: [GENERAL] Difference between ON and WHERE in JOINs

Le 19/09/2012 17:08, Merlin Moncure a écrit : SELECT * FROM foo LEFT JOIN BAR ON foo.id = bar.id AND bar.col = 'something'; The difference here is that the filtering is now happening at join time where the left join semantics are playing: always return foo and return bar rows if and only if the

Re: [GENERAL] Difference between ON and WHERE in JOINs

David, Thanks for the verbose explanations, really useful. However, in my case : - type is never NULL - there are no lines from uidinoldgroups that match the "FROM ldap" join. But I think I got it : drop table if exists tmpA; drop table if exists tmpB; create temp table tmpA (name varchar); in

Fwd: [GENERAL] URGENT ! Nouveau virus

e ! Denis Bucher === -- Jean-Christophe Boggio [EMAIL PROTECTED] -o) Independant Consultant and Developer /\\ Delphi, Linux, Perl, PostgreSQL _\_V ---(end of broadcast

Re: [GENERAL] Error creating tables.

omagic sequence created when you declare a SERIAL field). You can try : DROP SEQUENCE test_id_seq; Just guessing... -- Jean-Christophe Boggio [EMAIL PROTECTED] Independant Consultant and Developer Delphi, Linux, Oracle, Perl

[GENERAL] Request regarding logs

was meaningless, this is why I tried to say things differently. My apologies for the ~repost -- Jean-Christophe Boggio [EMAIL PROTECTED] Independant Consultant and Developer Delphi, Linux, Perl, PostgreSQL ---(end of broadcast)--- TIP 5: Have

Re: [GENERAL] INSERT ... RETURNING as Oracle

Just wanted to add that PHP has a GETLASTOID function that will work (after an insert) even if you don't use sequences/serials. -- Jean-Christophe Boggio [EMAIL PROTECTED] Independant Consultant and Developer Delphi, Linux, Perl, PostgreSQL ---(end of broa

[GENERAL] Where's that doc on plans ?

A few days ago I read a very interesting doc about postgres' query planner, how to read an EXPLAIN plan, how is a cost calculated, etc. but I can't find it anymore. Anyone has an idea ? Thanks in advance. -- Jean-Christophe Boggio [EMAIL PROTECTED] Independant Consultant and Develo

Re[2]: [GENERAL] Unexplained behaviour

cular backend.) Did not know that. Precious information ! -- Jean-Christophe Boggio [EMAIL PROTECTED] Independant Consultant and Developer Delphi, Linux, Perl, PostgreSQL ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please sen