Re: Creating a Pseudocolumn

On 5/16/06, Martijn van Oosterhout <kleptog@svana.org> wrote:
> I'm assuming that what's actually being implemented is the SQL standard
> method with the Oracle alternative being another way of specifying the
> same thing?

I'm working on both versions of hierarchical queries; CONNECT BY for
EnterpriseDB and WITH [RECURSIVE] for PostgreSQL.  Currently, they're
completely separate implementations, but in a few months I should be
able to translate CONNECT BY into actual WITH syntax.

Anyway, I'm working on the CONNECT BY version and am looking at how
best to implement the level pseudocolumn.  In the pseudocolumn
respect, this is somewhat similar to the rownum discussion.

I've added a system attribute to handle level, and it does work.  But,
I'm thinking there's going to be a couple gotcha's hidden in there
somewhere.

--
Jonah H. Harris, Software Architect | phone: 732.331.1300
EnterpriseDB Corporation            | fax: 732.331.1301
33 Wood Ave S, 2nd Floor            | jharris@enterprisedb.com
Iselin, New Jersey 08830            | http://www.enterprisedb.com/