Re: Convert stmt back into queryString

On Tue, Aug 04, 2009 at 10:00:24PM -0400, Tom Lane wrote:
> Dan Colish <dan@unencrypted.org> writes:
> >     I am currently trying to convert an insertstmt back into a const
> >     char *queryString, but I can't find an existing function to do this
> >     for the life of me.  I will write one if none exits, but I figured I
> >     ask here first.  Unfortunately, nodeToString is not quite right for
> >     what I'm doing. Thanks in advance.
> 
> Hmm, you mean a Query, or a raw unanalyzed InsertStmt?  If the former,
> ruleutils.c will help.  If the latter, be prepared to write a lot of
> code; there's nothing closer than nodeToString, and even that is pretty
> incomplete for raw grammar output nodes IIRC.
> 
>             regards, tom lane

In this case, its a raw InsertStmt. I would like to pass this back to
parse_analyze, but I need to have a queryString to go with that call, so
crafting a function to rate that seems to be the only way, atm.

--
--Dan