I'd also add (recursive) common table expressions, check constraints and deferrable constraints to that list.
Oh one thing that should be corrected in the list: PostgreSQL *does* compression on character data: http://www.postgresql.org/docs/9.0/static/storage-toast.html On Jun 17, 9:49 am, Lukas Eder <[email protected]> wrote: > I have come across this list here: > > http://www.h2database.com/html/features.html#comparison > > To make this list a little less biased towards H2 :) ...I think it > might be interesting to add these two features: > > - Window functions (only Postgres, so far) > - PL/SQL-like stored procedure syntax (HSQLDB, MySQL, Postgres). The > advantage of this over Java stored procedures is better readability > and maintainability (as some might argue), as well as faster > compilation. > > Also, a comparison with Firebird might be interesting, too > > Cheers > Lukas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
