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@xxxxxx --------------------------------------------------------------- ---------------------------(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