Re: Railroad diagrams, a-la sqlite

On 7/17/10 1:26 PM, Thom Brown wrote:
> On 17 July 2010 21:23, Dave Page <dpage@pgadmin.org> wrote:
>> On Sat, Jul 17, 2010 at 9:19 PM, Thom Brown <thombrown@gmail.com> wrote:
>>> While they're quite attractive, I actually see them being more
>>> confusing than helpful personally, but I could be wrong.  I reckon
>>> there might be clearer ways of representing statement options.  The
>>> real problems with the railroad design come when there are lots of
>>> references to other diagrams, and you end up with about 10 just for 1
>>> statement.
>>>
>>> Is there a way of testing their usefulness?
>>
>> Personal experience? I used to find them quite useful when I was
>> starting out with Informix.
>>
>
> I guess I'm quite used to the existing statement definitions.  It's an
> elegant idea, just wondering if it scales sanely.  Are the examples of
> more complex statements?

Oracle SELECT:

http://download.oracle.com/docs/cd/B14117_01/server.101/b10759/statements_10002.htm

Joe

--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support