On Tuesday 23 April 2002 15:04, Tom Lane wrote:
> John Taylor <postgres@jtresponse.co.uk> writes:
> > I am aware that I am using almost the same select from orderheader 3
> > times, but I'm not sure how I can improve on this.
>
> Can you do this?
>
> INSERT INTO target SELECT foo, bar, baz FROM source WHERE condition
>
> To the extent that you are computing multiple fields from the same
> row in the source table, this will help.
Where would I do that ?
Do you mean to select the order number (theorder) into a temporary table ?
The problem is that I need to use the order number in 3 seperate subselects.
>
> Also, avoid that IN construct.
OK. Thats done.
Thanks
JohnT