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/Papers-Other/SQL1999/ > -----Original Message----- > From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general- > owner@xxxxxxxxxxxxxx] On Behalf Of Mark Harrison > Sent: Monday, May 23, 2005 10:18 AM > To: pgsql-general@xxxxxxxxxxxxxx > Subject: 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
