Nikhil Sontakke wrote: > > > PFA, patch which uses find_coercion_pathway to find a direct > > > COERCION_PATH_FUNC function and uses that if it is available. Or is there > > a > > > better approach? Seems to handle the above issue with this patch. > > > > +1 > > > > I thing, so some values should by cached, current patch could by slow. > > > Agreed, it can slow things down a bit especially since we are only > interested in the COERCION_PATH_FUNC case. What we need is a much simpler > pathway function which searches in the SysCache and returns back with the > valid/invalid castfunc immediately. > > PFA, version 2.0 of this patch with these changes in place. I could have > added a generic function in parse_coerce.c, but thought the use case was > restricted to plpgsql and hence I have kept it within pl_exec.c for now.
Where are we on this? 8.5? -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers