Stephan Szabo <[EMAIL PROTECTED]> writes: > On Thu, 25 Mar 2004, Qing Zhao wrote: >> start with customer_part_number = 'Top Assembly 1' >> connect by parent_part_number = prior customer_part_number;
> What version are you running, and did you apply any patches (for example > one to support the start with/connect by syntax used above?) Oh, good eye ... it's that infamous CONNECT BY patch again, without doubt. I think we should add "Have you applied any patches to your copy of Postgres?" to the standard bug report form ... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])