Robert Haas wrote: > On Sat, May 29, 2010 at 5:00 PM, Bruce Momjian <br...@momjian.us> wrote: > > I have updated the patch, attached, to clarify that this returns text > > arrays, and that you can force it to always return one row using > > COALESCE() and a '|' pattern (the later suggested by Daniele Varrazzo). > > I don't find this part to be something we should include in the > documentation. If we want to include a workaround, how about defining > a non-SRF that just calls the SRF and returns the first row?
Remember this has to return one row for no matches, so a simple SRF will not work. I also have not seen enough demand for another function. A single doc mention seemed the appropriate level of detail for this. -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs