EXPLAIN EXTENDED

How to create fast database queries

Archive for April 22nd, 2009

Counting missing rows: PostgreSQL

Comments enabled. I *really* need your comment

This is the 5^th of 5 articles covering implementation of NOT IN predicate in several RDBMS'es:

NOT IN in MySQL
NOT IN in MySQL (using DISTINCT)
NOT IN in SQL Server
NOT IN in Oracle
NOT IN in PostgreSQL

Finally let's look how PostgreSQL copes with this predicate.

Let's create sample tables:
Read the rest of this entry »

Written by Quassnoi

April 22nd, 2009 at 11:00 pm

Posted in PostgreSQL

Subscribe

Subscribe in a reader

Subscribe by email

Contacts

Ask me a question

Drop me a line

Should I?

Yes. Feel free to ask questions and write me. An interesting question is a pleasure to answer, and I really enjoy receiving feedback

Recent articles

Calendar

Archives

Categories

Stack Overflow