> Chris, any chance you can send a small reproducable test case for this,
> with INSERT's and CREATE table. Thanks.
> > COALESCE sql function causes postgres to CRASH!
> > e.g.
> > httpd=> SELECT story.title, COALESCE(story.image, mfr.image) FROM story,
> > mfr where story.category= mfr.oid;
Not necessary. This was a known problem documented in the regression
tests, and Tom Lane just fixed it a day or two ago. The problem was
with including more than one table in a COALESCE or CASE expression
result.
- Tom
--
Thomas Lockhart lockhart@alumni.caltech.edu
South Pasadena, California