From: | Stefan Schwarzer <stefan(dot)schwarzer(at)grid(dot)unep(dot)ch> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: UNION not working... why? |
Date: | 2007-12-14 07:07:41 |
Message-ID: | 1B2BDD49-E6EC-4D9C-84B9-5AF9519A666A@grid.unep.ch |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
>> But now, I have another problem in this context. If I use text in the
>> SELECT statement (so, that the final output gives me the name of the
>> selected variables, plus the year and the value) than I get this
>> error message: ERROR: failed to find conversion function from
>> "unknown" to text
>
> [squint...] Try casting those literals to text explicitly, ie
> SELECT 'pop_density'::text AS name. There's some code in there
> that makes this work for simple UNION cases, but maybe not so much
> for select with a left join and order by and limit inside a union :-(
You guys are really great! Yep, it works like that like a charm...
Thanks a lot for your help!
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Smith | 2007-12-14 07:16:35 | Re: Need to find out which process is hitting hda |
Previous Message | Tom Lane | 2007-12-14 07:00:04 | Re: UNION not working... why? |