to perform hierarchical queries on PgSQL using Oracle's syntax.
On Mar 25, 2004, at 2:57 PM, Stephan Szabo wrote:
On Thu, 25 Mar 2004, Qing Zhao wrote:
_level_ as l,
nextval('seq_pk_bom_detail') as bom_detail,
prior nextval('seq_pk_bom_detail') as parent_subassembly,
when null then 0.00001
when 0 then 0.00001
and file_number = 1
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?)