| From: | Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu> |
|---|---|
| To: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | Chris Bitmead <chris(dot)bitmead(at)bigfoot(dot)com>, pgsql-hackers(at)hub(dot)org |
| Subject: | Re: [HACKERS] It would be nice if this could be fixed... |
| Date: | 1999-05-10 17:33:13 |
| Message-ID: | 37371859.C975F530@alumni.caltech.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> 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(at)alumni(dot)caltech(dot)edu
South Pasadena, California
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Lockhart | 1999-05-10 17:35:57 | Re: [HACKERS] problems with parser |
| Previous Message | Tom Lane | 1999-05-10 17:31:42 | Re: [HACKERS] views and group by (formerly: create view as selec |