Re: [SQL] plperl

Time Co-Ordinate Tue, 05 Jun 2001 19:45:55 -0400, The Organism labeled Tom Lane said: > clayton cottingham <[EMAIL PROTECTED]> writes: > > how does one execute an sql statement from inside a plperl function? > > At the moment, one doesn't. > > This is one of a number of features that have

[SQL] help with a function

consider this function: CREATE FUNCTION "test" (integer) RETURNS text AS 'return "select * from testt limit $_[o];";' LANGUAGE 'plperl'; how would i get it to just run the query instead of just return it as text using plperl? ---(end of broadcast)

[SQL] list of returns types for functions

is there a list of all possible returns for all procedural language types? aka perl can return these types c can return these .. thanks! ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [SQL] any proper benchmark scripts?

hello on the modperl list a good thread was happening called 'fast db access' find attached scripts used to do this here are my results: [drfrog]$ perl fast_db.pl postgres 16 wallclock secs ( 0.05 usr + 0.00 sys = 0.05 CPU) @ 400.00/s (n=20) mysql 3 wallclock secs ( 0.07 usr +

Re: [SQL] trigger examples

Carolyn Lu Wong wrote: > > I need to write a trigger to create a new record in log table if it's a > new record or if column A and B changes. Can someone give me an example > how to do this. > > Are there any sites that gives trigger examples?? > > Thanks. the fulltextindex in the contrib dir

Re: [SQL] pg_hba.conf

Craig May wrote: > > I've renamed the file to "pg_hba.conf". It's owner and groug are now postgres. > The file is located in /usr/lib/pgsql/. I'm still receiving the same error. > if you are running redhat 6.X as i suspect you should place that file in /var/lib/pgsql not /usr/lib/pgsql ch

[SQL] db benchmarks

does anyone have links to independent benchmarks just mysql vs postgresql would be cool the last one that came out was from Great Bridge has been contested by many {including mysql} i was wondering if anyone here does have independent benchmarks id sure appreciate

[SQL] using a self referencing table

i have a table with this structure name (varchar)|category id (int4)|parent category id (int4)|leaf node (bool) im trying to make a perl script that should tree the info parent cat subcat subcat2 subcat2 subcat subcat2 ... but

Re: [SQL] pg_dump problem

Ed Loehr wrote: > > Graham Vickrage wrote: > > > > I am trying to backup a production database running on v6.5 and restore it > > on our test machine running v6.5. > > > > The largest table has about 750,000 rows, the other 5 tables are very small > > approx 100 rows. > > > > When I try to restor