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

[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

Fwd: [GENERAL] URGENT ! Nouveau virus

-Christophe Boggio [EMAIL PROTECTED] -o) Independant Consultant and Developer /\\ Delphi, Linux, Perl, PostgreSQL _\_V ---(end of broadcast)--- TIP 6: Have you searched our list archives

Re[2]: [GENERAL] Unexplained behaviour

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 send an appropriate subscribe-nomail command to [EMAIL

[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 Developer Delphi

[GENERAL] Request regarding logs

s 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 you checked our ext

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 broadcast

Re: [GENERAL] Error creating tables.

). You can try : DROP SEQUENCE test_id_seq; Just guessing... -- Jean-Christophe Boggio [EMAIL PROTECTED] Independant Consultant and Developer Delphi, Linux, Oracle, Perl