Re: Is SQL silly as an RDBMS<->app interface? - Mailing list pgsql-general

From Ron Johnson
Subject Re: Is SQL silly as an RDBMS<->app interface?
Date
Msg-id 1058218390.19798.188.camel@haggis
Whole thread Raw
In response to Re: Is SQL silly as an RDBMS<->app interface?  (Peter Childs <blue.dragon@blueyonder.co.uk>)
List pgsql-general
On Mon, 2003-07-14 at 04:36, Peter Childs wrote:
> On Mon, 14 Jul 2003, Alvaro Herrera wrote:
>
> > On Mon, Jul 14, 2003 at 12:54:55AM -0500, Ron Johnson wrote:
[snip]
>     SQL is almost the worst standard I've come across. Its the
> computer equivalent of VHS. Its not readable by computer or humans. (Enough
> Flaming on to why I think this)
>
>     SQL is verbose it often make you repeat your self when its obvious
> what you mean.
>
> INSERT INTO a (b,c) SELECT a+4 as b, c*6 as c from a;

Without a WHERE clause, would that "just" double the number of
tuples, or recurse forever?

>     SQL has many different ways of writing the same thing for
> different purposes. eg
> INSERT INTO a (b,c) VALUES (1,2);
> UPDATE a set b=1, c=2 WHERE d=3;
>
> Why not
>
> INSERT INTO a set b=1, c=3;
>
> its certainly more readable and consistent.

That's debatable.

If fields b and c are the only fields in the table, you can say:
  INSERT INTO A VALUES (1, 2);
When there's a dozen fields in table A, your method seems that
it would get pretty unwieldy.

--
+-----------------------------------------------------------+
| Ron Johnson, Jr.     Home: ron.l.johnson@cox.net          |
| Jefferson, LA  USA   http://members.cox.net/ron.l.johnson |
|                                                           |
| 4 degrees from Vladimir Putin
+-----------------------------------------------------------+


pgsql-general by date:

Previous
From: Zengfa Gao
Date:
Subject: Lock file "/tmp/.s.PGSQL.5432.lock" already exists.
Next
From: "Jay O'Connor"
Date:
Subject: more performance questions