[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

[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

[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

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 some

[GENERAL] Returning multiple rows from a function?

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, but had no luck. Thanks, Bret -- Bret Schuhmacher [EMAIL PROTECTED] ---(end