Re: Howto analyse sql statement.

From: Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>
To: moch_isnaini(at)yahoo(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Howto analyse sql statement.
Date: 2010-02-18 07:08:52
Message-ID: 20100218.160852.58453145.t-ishii@sraoss.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

From: Muhammad Isnaini <moch_isnaini(at)yahoo(dot)com>
Subject: Re: Howto analyse sql statement.
Date: Wed, 17 Feb 2010 21:02:26 +0800 (SGT)
Message-ID: <525621(dot)291(dot)qm(at)web76202(dot)mail(dot)sg1(dot)yahoo(dot)com>

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

Browse pgsql-general by date

  From Date Subject
Next Message Carsten Kropf 2010-02-18 07:32:19 Trying to add a type modifier to user created type
Previous Message Tatsuo Ishii 2010-02-18 06:56:12 Re: pgpool error, pid not found!