How to create/initialize/access an execution plan

Hi all,

I need a help and an advice on playing around execution plans. I need a direct
access to a 'plan structure' and change some fields. Even one step more, I
need to create an execution plan directly w/o issuing an SQL statement (i.e.
skipping parser and optimizer phases) and initialize (fill in the fields) it.

I searched a lot to find a suitable documentation and example set, but I
couldn't find any. If you give some advices on how to create a plan
node/structure (directly w/o an sql statement or query tree assuming
that I have my own plan in my mind) and how to play around it (change
fields), I would really appreciate it.

Thanks in advance,

PS: I tried to access fields of a plan returned by SPI_prepare(), but I
couldn't manage it either.

----------------------------------------
This mail sent through www.mywaterloo.ca