--- Tony Caduto <[EMAIL PROTECTED]> 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

Reply via email to