[GENERAL] using regexp_matches and array manipulation

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Can anyone give me an example of how to use regexp_matches and use the captured values? For instance, if I have a delimited string "a,b,c" and I want to put each letter into a variable so I can subsequently use those variables in an insert statem

[GENERAL] PG/Tcl and Expect?

Does the PG/Tcl interface allow expect scripts? I want to create a stored procedure that ssh's to another server and runs a Perl script. Expect could do it, but can I load the expect module from pgtcl? Thanks, Bret

Re: [GENERAL] Suggestions for Remote Procedure Calls from PG, please?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Tom Lane wrote: > > > You've almost figured out the big problem with anything like this; > the trouble spot is the other way around. What if you launch some > remote operation, and it succeeds, and then later your own transaction > rolls back for som

[GENERAL] Suggestions for Remote Procedure Calls from PG, please?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 What's the best way to invoke a process on another server from a PG trigger or procedure? I was thinking of using pl/java to invoke a web service on the other box... Can pl/tcl run Expect scripts? That'd be an option, too. Or I could use XMLBlaste

[GENERAL] Returning multiple rows from a function?

(i.e. select getOnCallVol()), I get this: (Mary,Smith,11,22,33,"","") Is there another way to get each row returned? I played around with making the function return a "SETOF RECORD" and using "RETURN NEXT", bu