I have used PL/SQL for years. It's a great language that is easy to pick up and offers lots of ability/promise.  The syntax seems very easy for new people to pick up who might know another language or are just starting out.  Of course the same can be said of Ada code.  It's just very easy to read.

On 7/1/05, [EMAIL PROTECTED] <[EMAIL PROTECTED] > wrote:
> Out of curiosity, what other backends do you consider and what is their
> syntax for such problems.

Most folks that use Oracle's PL/SQL like it.  I have a sneaking suspicion
Oracle used the GNAT parser for Ada as a starting point, but that is pure
conjecture.  Oracle does document that PL/SQL is Ada with SQL extensions.
An enterprising individual could get the source for GNAT from AdaCore (it's
GPL'd) and create a workalike language for PostgreSQL.  I'm not
enterprising.

Rick

[EMAIL PROTECTED] wrote on 06/30/2005 04:03:49 PM:

> On 6/30/05, Jason Tesser <[EMAIL PROTECTED]> wrote:
> > I work for a college and we use PG currently as our main backend.  We
are
> > currently developing with Java.  We are considering moving away
> from postgres
> > for the reasons I am going to list below.  I would appreciate some
thoughts
> > from the Postgres community on way we should or shouldn't leave
postgres.
>
> Out of curiosity, what other backends do you consider and what is their
> syntax for such problems.  Don't get me wrong, I don't intend to prove
> anything by asking so.  I am just curious what syntax would you prefer,
> or in other words, what syntax is most convenient for a person doing
> procedural language intense project.  Hopefully it will help PL/pgSQL
> develop in a best direction.
>
> So, please post samples of syntax (and a DB-name, I'm curious about
> other DBs syntaxes).
>
>    Regards,
>      Dawid
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply via email to