On Tue, 25 May 1999, Chris Bitmead wrote:
What does this have to do with pl/pgsql?
# It's extremely straight-forward..
# $q = $dbh->prepare("SELECT x,y,z from b where c = ?");
# $q->execute("foo");
# while (($x, $y, $z) = $q->fetchrow())) {
# #stuff
# }
#
# $q = $dbh->prepare("INSERT I
That's an example of performing procedural tasks using Perl as the
procedural language with access to the database.
I think what Mike is looking for are examples of using PL/pgSQL. Which, as
it where, is a procedural language 'internal' to postgreSQL (well that a
very bad way of putting it but I
It's extremely straight-forward..
$q = $dbh->prepare("SELECT x,y,z from b where c = ?");
$q->execute("foo");
while (($x, $y, $z) = $q->fetchrow())) {
#stuff
}
$q = $dbh->prepare("INSERT INTO a(x,y,z) values(?,?,?);
$q->execute($x,$y,$z);
Mike Haberman wrote:
>
> I too need more info on PL/pgS
I too need more info on PL/pgSQL than the docs supply.
Is it possible for people to mail me any examples of PL/pgSQL. I
just need to see examples of the syntax of the various control
sturctures, variable assignment, and the like.
>From simple to very complex, send anything that might be helpf
The only thing that I know is whats in the docs and whats in the src
directory. I'd like to see/read more. I was going to pick up a Oracle book
on it but, I'm afraid that PL/pgSQL and PL/SQL aren't the same.
Thanks
Andy
On Sat, 22 May 1999, dustin sallings wrote:
> On Sat, 22 May 1999, Andy Le
