Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] PL/pgSQL - mailng list

From: Chris Bitmead <chris(dot)bitmead(at)bigfoot(dot)com>
To: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] PL/pgSQL - mailng list
Date: 1999-05-24 15:04:10
Message-ID: 37496A6A.82E3FE7E@bigfoot.com (view raw or flat)
Thread:
Lists: pgsql-general
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

In response to

Responses

pgsql-general by date

Next:From: Stuart RisonDate: 1999-05-24 15:30:56
Subject: Re: [GENERAL] PL/pgSQL - mailng list
Previous:From: Ross J. ReedstromDate: 1999-05-24 14:48:40
Subject: Re: [GENERAL] Full Text Searches

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group