Re: Creating a Pseudocolumn

"Jonah H. Harris" <jonah.harris@gmail.com> writes:
> I'm reworking hierarchical queries and am adding a LEVEL pseudocolumn.
>  As it's a totally calculated attribute, what's the best way to handle
> it keeping in mind that LEVEL is only used in a hierarchical query?

Perhaps you should start by explaining what the heck you're talking
about ;-).  I can find nothing in the SQL2003 spec that sounds anything
like a LEVEL function or pseudocolumn.
        regards, tom lane