At 2008-07-23 10:50:03 -0400, [EMAIL PROTECTED] wrote: > > > What would the function return? "CREATE OR REPLACE FUNCTION ..."? > > I think I'd go with CREATE FUNCTION for simplicity.
OK, I have a mostly working pg_get_functiondef now, and some questions about the remaining pieces: 1. Why is "prorows" a float4? Should I print it that way, i.e. "%f"? 2. Can I print the contents of "proconfig" as just "SET %s"? It seems to work for the variables I've tried (e.g. "DateStyle=iso"), but I wonder if they'll always be quoted correctly (i.e., if the "split on '='" thing pg_dump does is necessary for an 8.4 function). 3. Is there a function I can use from ruleutils.c to do dollar quoting of prosrc/probin? If not, and I have to write one, where should it live? 4. What exactly is probin? Do I need to worry about it at all? Thanks. -- ams -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
