[GENERAL] file I/O in plpgsql

2006-04-29 Thread Jessica M Salmon
I'm trying to write out query results to a text file from within a plpgsql function, but having trouble. Can anyone tell me if this is possible? I'm trying to perform \o filename, then select, but it squawks about no destination for the select results. Any pointers? -Meghan -

Re: [GENERAL] file I/O in plpgsql

2006-05-02 Thread Jessica M Salmon
Thanks everyone for their input on this. -Meghan ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

[GENERAL] composite data type question

2006-06-07 Thread Jessica M Salmon
Hello all. I am brand new to creating my own data types in postgres. I first created a type called "indices", containing two integers. Now, I want to create another type, called "progress", which should contain one timestamp and an array of "indices". However, I cannot figure out how to get postg

Re: [GENERAL] composite data type question

2006-06-08 Thread Jessica M Salmon
Michael Fuhr <[EMAIL PROTECTED]> To 06/07/2006 07:59 Jessica M

[GENERAL] loop with circular updates

2006-07-26 Thread Jessica M Salmon
Hi All. I'm writing a plpgsql function that creates a table and loops over the items in that table, using a FOR ... IN EXECUTE ... loop. The thing is, on each iteration I update the table over which I am looping. Sometimes, the result of this update makes it no longer necessary/desirable to proce

Re: [GENERAL] loop with circular updates

2006-07-28 Thread Jessica M Salmon
neth Downs <[EMAIL PROTECTED]> To 07/26/2006 08:50 Jessica M Salmon

Re: [GENERAL] loop with circular updates

2006-07-30 Thread Jessica M Salmon
TED] s> To Jessica M Salmon 07/28/2006 09:46 <[EMAIL PROTECTED]>