Re: [GENERAL] About functions

2000-02-24 Thread Peter Eisentraut
On 2000-02-23, Diego Schvartzman mentioned: > Is it possible to return a row or a set of rows from a user defined funcion? > Can I use user defined functions as "stored procedures"? No. Several workarounds, such as using arrays or views are known, but none really suffice. -- Peter Eisentraut

Re: [GENERAL] Re: [General] pgsql on win95

2000-02-24 Thread Dustin Sallings
On Thu, 24 Feb 2000, root wrote: # > I'm writing this email to you from a notebook. Running Linux. And Postgres. # > :-) So, it's already being done (Notebooks aren't the issue here, I believe # > it's an issue of OS choices). # # There're still some Windows'95 and Windows'98 users out there in

Re: [GENERAL] Re: [HACKERS] TRANSACTIONS

2000-02-24 Thread Lincoln Yeoh
At 02:16 PM 24-02-2000 -0500, Karl DeBisschop wrote: > >To summarize, I stated that the following does not work with >postgresql: > >> $dbh->{AutoCommit} = 0; >> $dbh->do("CREATE TABLE tmp (a int unique,b int)"); >> $rtv = $dbh->do("INSERT INTO tmp VALUES ($1,$2)"); >> if ($rtv) {$