[ADMIN] experimenting with coalesce, strange EXPLAIN results

2003-09-04 Thread Josh Goldberg
I was experimenting with moving some of my case logic out of the application and into sql and found a strange EXPLAIN result with one of my COALESCE statements. Why is each subselect listed twice? This is in 7.3.4 on freebsd 4.8. cms3=# explain analyze select coalesce ((sELECT thumb FROM

Re: [ADMIN] experimenting with coalesce, strange EXPLAIN results

2003-09-04 Thread Tom Lane
Josh Goldberg [EMAIL PROTECTED] writes: I was experimenting with moving some of my case logic out of the application and into sql and found a strange EXPLAIN result with one of my COALESCE statements. Why is each subselect listed twice? This is in 7.3.4 on freebsd 4.8. Prior to 7.4,