On Aug 5, 2010, at 11:42 AM, Thom Brown wrote:
>>> LINE 1: select string_agg(f1 order by f1, ',') from text_tbl;
>>> ^
>>
>> I'm confused: that looks like the two-argument form to me. Have I missed
>> something?
>>
>>> HINT: No function matches the given name and argument types. You might
>>> need to add explicit type casts.
>>>
>>> It's not perfect (I don't think it's practical to get the HINT to
>>> read "Put the ORDER BY at the end" ;-)) but at least it should
>>> get people pointed in the right direction when they do this.
>>
>> It confuses the shit out of me. It says "string_agg(text)" doesn't exist
>> when that clearly is not the name of the function you've called.
>>
>
> What function name do you believe was called?
The message says:
string_agg(f1 order by f1, ',')
That looks like string_agg(text, text) or string_agg(anyelement, text).
Best,
David
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
