I've been searching for books and web sites to help me learn SQL/PSM. Unfortunately, everybody seems to have their own flavour of SQL/PSM, and nobody implements the whole standard, although I like the PostgreSQL idea of having a CASE within a SELECT statement. Very flexible.

Are there any books or web sites that I can reference that are useful for ElevateDB's brand of SQL/PSM? I have found some general SQL books which cover the 2003 standard:

Understanding the New SQL, by Jim Melton and Alan R Simon
SQL In A Nutshell, by Kevin Kline, Daniel Kline and Brand Hunt
SQL Bible, by Alex Kriegel and Boris M Trukhnov

Richard,

<< I've been searching for books and web sites to help me learn SQL/PSM.
Unfortunately, everybody seems to have their own flavour of SQL/PSM, and
nobody implements the whole standard, although I like the PostgreSQL idea of
having a CASE within a SELECT statement. Very flexible. >>

ElevateDB supports CASE inside of a SELECT statement - that isn't SQL/PSM,
but rather a normal SQL construct.

<<Are there any books or web sites that I can reference that are useful for
ElevateDB's brand of SQL/PSM? I have found some general SQL books which
cover the 2003 standard: >>

The easiest reference is the actual ElevateDB SQL manual itself:

http://www.elevatesoft.com/manual?action=topics&id=edb2sql&section=sql_psm_statements

The only major differences between the standard and ElevateDB's SQL/PSM is
the inclusion of the dynamic SQL (PREPARE/EXECUTE/EXECUTE IMMEDIATE), the
different exception handling (BEGIN..EXCEPTION in ElevateDB), and the
restriction on DECLARE only appearing once in ElevateDB.

--
Tim Young
Elevate Software
www.elevatesoft.com

"Tim Young [Elevate Software]" wrote:

Richard,

<< I've been searching for books and web sites to help me learn SQL/PSM.
Unfortunately, everybody seems to have their own flavour of SQL/PSM, and
nobody implements the whole standard, although I like the PostgreSQL idea of
having a CASE within a SELECT statement. Very flexible. >>

ElevateDB supports CASE inside of a SELECT statement - that isn't SQL/PSM,
but rather a normal SQL construct.


Yes, I know now. I hadn't yet reached page 386 of the SQL manual when I wrote my original message. I probably should have finished the whole thing before posting.

Richard,

<< Yes, I know now. I hadn't yet reached page 386 of the SQL manual when I
wrote my original message. I probably should have finished the whole thing
before posting. >>

No, there's no problem with your post at all - I was simply clarifying the
situation.  Please post any question you may have - it helps others that may
have the same question.

--
Tim Young
Elevate Software
www.elevatesoft.com

>> The easiest reference is the actual ElevateDB SQL manual itself:

>> http://www.elevatesoft.com/manual?action=topics&id=edb2sql§ion=sql_psm_statements

Reading manuals?  That's crazy talk!  What is the world coming to?

Steven,

<< Reading manuals?  That's crazy talk!  What is the world coming to? >>

In this case it actually is the only real solution, also.  There isn't
much out there about SQL/PSM in general, mainly because everyone uses a
variant of it, or a completely different stored procedure syntax altogether
like Transact-SQL.

--
Tim Young
Elevate Software
www.elevatesoft.com

Hi Tim,

> In this case it actually is the only real solution, also.  There isn't
> much out there about SQL/PSM in general, mainly because everyone uses a
> variant of it, or a completely different stored procedure syntax altogether
> like Transact-SQL.

I actually refer to the ElevateDB SQL manual quite a lot as I find it very useful, especially when I have to switch between ElevateDB, Microsoft SQL Server and MySQL. It's one of the few SQL manuals that make any sense to my poor brain.

Steve