| From: | Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu> |
|---|---|
| To: | Chris Bitmead <chris(dot)bitmead(at)bigfoot(dot)com> |
| Cc: | pgsql-hackers(at)hub(dot)org |
| Subject: | Re: [HACKERS] It would be nice if this could be fixed... |
| Date: | 1999-05-03 17:04:29 |
| Message-ID: | 372DD71D.B5BF56E7@alumni.caltech.edu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> COALESCE sql function causes postgres to CRASH!
> httpd=> SELECT story.title, COALESCE(story.image, mfr.image)
> httpd-> FROM story, mfr where story.category= mfr.oid;
This is a known problem which I was hoping someone would pick up and
try to fix. Not sure I'll have time to look at it before v6.5 is
released.
The problem is in combining columns from multiple tables in the
COALESCE result. There are commented-out examples in the regression
test which illustrate the "feature". Other features of COALESCE seem
to work OK...
- Tom
--
Thomas Lockhart lockhart(at)alumni(dot)caltech(dot)edu
South Pasadena, California
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Lockhart | 1999-05-03 17:23:06 | Re: [HACKERS] GROUP BY fixes committed |
| Previous Message | Ross J. Reedstrom | 1999-05-03 17:01:31 | pg_dump bug (was Re: [SQL] Slow Inserts Again) |