Re: [GENERAL] Optimising "full outer join where" for muti-row to multi-column view

2006-12-28 Thread Martijn van Oosterhout
On Thu, Dec 28, 2006 at 08:29:56PM +, Phil Endecott wrote: > To try and avoid this, I tried using a full outer join in the view > definition. In this case the row would always be present in the view, > even if the data for the other columns were not present. I hoped that > the query would

[GENERAL] Optimising "full outer join where" for muti-row to multi-column view

2006-12-28 Thread Phil Endecott
Dear PostgreSQL experts, I have a database that records the EXIF data for a collection of photos. (EXIF is a method for embedding arbitary name-value data in a JPEG, and digital cameras typically use it to record things like exposure information.) My exif table looks something like this: p