--- Tony Caduto <tony_caduto@amsoftwaredesign.com> wrote:
> Check it out here:
>
> http://www.amsoftwaredesign.com/pg_vs_fb
One row that you could elaborate on is:
CHECK CONSTRAINTS support for correlated sub-queries.
PostgreSQL doesn't official support this kink of constraint unless it is rolled up in a function.
I am not sure what support FB has for this.
Another Constraint row you could add would be:
CREATE ASSERTION which is a schema level constraint. Currently PostgreSQL doesn't support this,
I am not sure if FB does either.
Also you could mention PostgreSQL support for row-wise comparison:
i.e. WHERE ( last_name, city, gender ) = ( 'Doe', 'Paris', 'female' );
and PostgreSQL support for additional SQL comparison operators:
i.e. WHERE (( last_name, city, gender ) = ( 'Doe', 'Paris', 'female' )) IS UNKNOWN;
-- return all people who might meet this criteria if their null field where known.
Regards,
Richard Broersma Jr.