st 18. 3. 2020 v 18:09 odesílatel Tom Lane <tgl@sss.pgh.pa.us> napsal:
Pavel Stehule <pavel.stehule@gmail.com> writes: > st 18. 3. 2020 v 17:54 odesílatel Tom Lane <tgl@sss.pgh.pa.us> napsal: >> No, because if you've got that alongside foo2(anycompatible, >> anycompatible) then your queries will fail due to both functions >> matching anything that's promotable to text.
> It is working for anyelement
[ pokes at that... ] Hm, looks like you're getting away with that because of the preference for functions taking preferred types. Seems pretty shaky to me though --- you can probably invent cases that will throw 'ambiguous function' if you try a bit harder. In any case, I don't think users will understand why they have to write two versions of the same function.