Re: [GENERAL] PL/pgSQL - mailng list

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/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 helpful.
>
> thanks a ton
>
> mike haberman
> mikeh(at)ncsa(dot)uiuc(dot)edu
>
> >
> > On Sat, 22 May 1999, Andy Lewis wrote:
> >
> > How can we tell you more if we don't know what you know? It's
> > usually pretty safe to just go ahead and ask the question. You'll be
> > redirected if you've posted to the wrong place.
> >
> > // I'd just plain would like to know more about PL/pgSQL.
> > //
> > // Andy
> > //
> > // On Sat, 22 May 1999, Piotr Stelmaszyk wrote:
> > //
> > // > I'd like to get to know where should I post messages concerning
> > // > PL/pgSQL.
> > // >
> > // >
> > // > /--------------------------------------------------------/
> > // > /- Piotr Stelmaszyk |---- Student of Computer Science ---/
> > // > /------------------ | at Poznan University of Technology /
> > // > /----- mailto:kelman(at)fanthom(dot)math(dot)put(dot)poznan(dot)pl ---------/
> > // > /----- mailto:kelman(at)alpha(dot)net(dot)pl -----------------------/
> > // > /--------------------------------------------------------/
> > // >
> > // >
> > // >
> > //
> > //
> > //
> >
> > --
> > Principal Member Technical Staff, beyond.com The world is watching America,
> > pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin(at)spy(dot)net>
> > | Key fingerprint = 87 02 57 08 02 D0 DA D6 C8 0F 3E 65 51 98 D8 BE
> > L______________________________________________ and America is watching TV. __
> >
> >

--
Chris Bitmead
http://www.bigfoot.com/~chris.bitmead
mailto:chris(dot)bitmead(at)bigfoot(dot)com