[Catalyst] catalyst and oracle "CONNECT BY PRIOR"

[Ulf Lenski]

hi,
how can I use a query like:

SQL> SELECT a
 FROM test_table
 CONNECT BY PRIOR b=3Da
 =

in my controller like:
$c->stash->{a} =3D [ $c->model('MyAppDB::Bla')->search({ }, ???????????????=
? { }  )];


SQL> SELECT * FROM test_table;

          A              B
-----------     ----------
          1             -1
          2              1
          3              1
          4              2
          5              2
          6              4
          7              4
          8              5
          9              5
         10              3
         11              3

Can anyone help me here in the catalyst-list? =

Or post it to thedbix-list?


thanks - ulf.


p.s. : are there any experience with analog features for mysql?


-------------- next part --------------
A non-text attachment was scrubbed...
Name: lenski.vcf
Type: text/x-vcard
Size: 216 bytes
Desc: not available
Url : http://lists.scsys.co.uk/pipermail/catalyst/attachments/20080403/641a=
e270/lenski.vcf