--- Tony Caduto <tony_caduto@xxxxxxxxxxxxxxxxxxxx> 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. ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
