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