From: Muhammad Isnaini <moch_isnaini@xxxxxxxxx> Subject: Re: Howto analyse sql statement. Date: Wed, 17 Feb 2010 21:02:26 +0800 (SGT) Message-ID: <525621.291.qm@xxxxxxxxxxxxxxxxxxxxxxxxxxx> > > parse_tree_list = raw_parser(string); > > I have got it. I will send later. > Next chalange is how writing query statement ( include rewriting ) from a node ?. Is that posible ?. You could recursively search the parse tree and rewrite the query. See pool_timestamp.c for a great example. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general