> 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 pgsql-general-owner@xxxxxxxxxxxxxx wrote on 06/30/2005 04:03:49 PM: > On 6/30/05, Jason Tesser <jtesser@xxxxxxxx> 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 majordomo@xxxxxxxxxxxxxx) ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster