On 19/01/2008 18:22, Ivan Sergio Borgonovo wrote:
> Is there a place that gives examples of all the kind of queries
> postgresql support?

This may not be what you're looking for, but I've found O'Reilly's "SQL
Cookbook" (ISBN 0-596-00976-3) incredibly useful: it gives sample
solutions to all sorts of problems in SQL suitable for PostgreSQL,
MySQL, DB2, SQL Server and Oracle.

Ray.


---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
---------------------------------------------------------------

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match