From: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
To: Thom Brown <thombrown@gmail.com>
Cc: Joseph Conway <mail@joeconway.com>
Cc: Dave Page <dpage@pgadmin.org>
Cc: Steve Atkins <steve@blighty.com>
Cc: pgsql-docs <pgsql-docs@postgresql.org>
Subject: Re: Railroad diagrams, a-la sqlite
Date: Sat, 17 Jul 2010 23:42:53 +0300
Message-ID: <4C4215CD.6020500@enterprisedb.com> (raw)
In-Reply-To: <AANLkTikLI4bnKUw0VTk48swJAAEJbs1jCIXBPSyBq3Az@mail.gmail.com>
References: <2AACFC47-C121-4549-B015-AC4FCA9380CE@blighty.com>
<AANLkTikzQCj8kJPAINMSGjypjKbWxmcXe2WqWqeenKxU@mail.gmail.com>
<AANLkTiniHvonP00ltJgXsB1xOyUPggmrWA4V05PKov5L@mail.gmail.com>
<AANLkTimBZvb554biF3gZyVfFdAdswnj9AZdC03UVUzXw@mail.gmail.com>
<4C4212F8.1080704@joeconway.com>
<AANLkTikLI4bnKUw0VTk48swJAAEJbs1jCIXBPSyBq3Az@mail.gmail.com>
On 17/07/10 23:36, Thom Brown wrote:
> On 17 July 2010 21:30, Joseph Conway<mail@joeconway.com> wrote:
>> 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
>>
>
> Yeah, that kinda chaotic. Looks like a sadistic puzzle from the
> Krypton Factor. :S
Mind you, that syntax is genuinely complex. It would look chaotic using
the text representation we currently use as well.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: heikki.linnakangas@enterprisedb.com, thombrown@gmail.com, mail@joeconway.com, dpage@pgadmin.org, steve@blighty.com
Subject: Re: Railroad diagrams, a-la sqlite
In-Reply-To: <4C4215CD.6020500@enterprisedb.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox