| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | mikeo <mikeo(at)spectrumtelecorp(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: coalesce view error |
| Date: | 2000-06-16 14:22:46 |
| Message-ID: | 6866.961165366@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-patches |
mikeo <mikeo(at)spectrumtelecorp(dot)com> writes:
> thanks for the patch. one of my coworkers came up with a working
> solution:
>> Hi Mike, try adding ::text before the AS...
Hmm, offhand I do not see why that would work. The two fields you're
coalescing are both type text, no? In that case the cast ought to be
dropped out of the expression as redundant.
If the fields are varchar or bpchar, then casting to text would work
(at least in 7.0.*) because the parser would include an explicit
RelabelType node in the stored expression...
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2000-06-16 14:38:35 | Re: using max() aggregate |
| Previous Message | mikeo | 2000-06-16 14:10:23 | Re: coalesce view error |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2000-06-16 15:00:35 | Re: Big 7.1 open items |
| Previous Message | mikeo | 2000-06-16 14:10:23 | Re: coalesce view error |