|
Home > Archive > PostgreSQL Discussion > May 2005 > pointers to sql standard, or "most common" sql?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
pointers to sql standard, or "most common" sql?
|
|
| Mark Harrison 2005-05-23, 1:23 pm |
| So, I was trying to figure out which was close to standard sql:
select * from foo limit 10
or
set rowcount 10 select * from foo
and couldn't find much relevant information via google.
Is the sql standard on the web, and is there some document
about the syntax variations between sybase, oracle,
mysql, and postgresql?
Many TIA!
Mark
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
| |
| Scott Marlowe 2005-05-23, 1:23 pm |
| On Mon, 2005-05-23 at 12:18, Mark Harrison wrote:
> So, I was trying to figure out which was close to standard sql:
>
> select * from foo limit 10
> or
> set rowcount 10 select * from foo
>
> and couldn't find much relevant information via google.
>
> Is the sql standard on the web, and is there some document
> about the syntax variations between sybase, oracle,
> mysql, and postgresql?
Do a search for sql1992.txt and you can find the review drafts laying
about the net like so many old socks in a bachelor's apartment.
As for the limit syntax, it simply isn't part of the SQL 1992 spec.
You're expected to use cursors I guess.
So, of course, EVERY database implements it just a little bit
different. I think it was more a case of all the different interests in
the SQL 92 committee not being able to agree than disagreeing with the
idea of limit.
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
| |
| Dann Corbit 2005-05-23, 1:23 pm |
| You can buy the SQL Standard from ANSI in PDF format for $18 per book
(there are several books).
http://webstore.ansi.org/ansidocstore/find.asp?
Under "Search" type in SQL and hit the go button.
You can get draft versions for free. For instance:
http://www.cse.iitb.ac.in/dbms/Data...-Other/SQL1999/
> -----Original Message-----
> From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-
> owner@postgresql.org] On Behalf Of Mark Harrison
> Sent: Monday, May 23, 2005 10:18 AM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] pointers to sql standard, or "most common" sql?
>
> So, I was trying to figure out which was close to standard sql:
>
> select * from foo limit 10
> or
> set rowcount 10 select * from foo
>
> and couldn't find much relevant information via google.
>
> Is the sql standard on the web, and is there some document
> about the syntax variations between sybase, oracle,
> mysql, and postgresql?
>
> Many TIA!
>
> Mark
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
|
|
|
|
|