"Jonah H. Harris" <jonah(dot)harris(at)gmail(dot)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