Re: Convert stmt back into queryString

Dan Colish <dan(at)unencrypted(dot)org> writes:
> On Tue, Aug 04, 2009 at 10:00:24PM -0400, Tom Lane wrote:
>> Hmm, you mean a Query, or a raw unanalyzed InsertStmt?

> 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.

Hm, so you have an InsertStmt but not the text it was generated from?
Where? By and large the design plan is that the source text should
still be available anyplace that's dealing with raw parsetrees.

I believe you can just pass NULL as the querystring --- the only thing
you lose from that is syntax location pointers in error messages. But
in ordinary situations you shouldn't have to. (Also, the fact that
that's what the string is used for means that ginning up a string from
the nodetree is a bit pointless. It won't contain the detail that it's
meant to provide.)

regards, tom lane