We've also started automating sparse analyses in our PLM tool, which will show an error and warning count. Here's an example: http://www.osdl.org/plm-cgi/plm?module=patch_info&patch_id=4065
On Wed, Jan 12, 2005 at 02:18:36PM -0800, Mark Wong wrote: > Hi, > > Just wondering if anyone finds spare's analysis useful. I ran it > against 8.0-rc5: > http://developer.osdl.org/markw/pgsql/sparse/pg-8.0rc5.txt > > Sparse can be downloaded > http://www.codemonkey.org.uk/projects/bitkeeper/sparse/ > or > bk://sparse.bkbits.net/sparse > ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match