00:11:12 <recampbell> recampbell has quit
00:11:13 <GEM> GEM has quit
00:11:13 <rbm> rbm has quit
00:11:21 <rbm> rbm has joined #openacs
00:11:21 <recampbell> recampbell has joined #openacs
00:11:21 <GEM> GEM has joined #openacs
00:36:48 <ChanServ> ChanServ has changed the topic to: 
00:36:48 <ChanServ> This channel is logged: http://www.blogspace.com/openacs/chatlogs/ and blogged: http://www.thedesignexperience.org/openacs/ircblog
01:03:52 <talli> talli has joined #openacs
02:06:16 <tdxdave> tdxdave has changed the topic to: Welcom to the OpenACS Helpline http://openacs.org
02:06:22 <tdxdave> tdxdave has changed the topic to: Welcome to the OpenACS Helpline http://openacs.org
02:15:27 <tdxdave> * tdxdave loves emacs21 in X
02:33:02 <talli> talli has quit
02:40:53 <tdxdave> plpgsql question...
02:41:33 <tdxdave> the variable in a FOR loop must be a RECORD or ROW... so if I want to refer to the value of a field inside the LOOP i need to do:
02:41:44 <tdxdave> for_row.fieldname
02:42:39 <tdxdave> All the uses in Oracle are like  FOR folder_row SELECT folder_id FROM where it is setting the variable only to folder_id 
02:42:55 <tdxdave> Am I porting this correctly? It seems to work.
02:45:51 <tdxdave> Well I have to go now. Thanks! If anyone does read this and has an answer go ahead and post, I will read the log.
02:45:54 <tdxdave> tdxdave has quit
05:40:29 <abbaJ> abbaJ has quit
05:44:14 <abbaJ> abbaJ has joined #openacs
07:18:41 <vinod> vinod has joined #openacs
07:20:55 <vinod> tdxdave: was looking at the logs and saw your ?. You have it right. in plpgsql FOR loops, you reference the column you want by my_rec.col_name (even if you're only selecting one column)
08:52:23 <ola> ola has joined #openacs
11:20:43 <til> til has joined #openacs
11:21:56 <til> til has quit
11:23:36 <ola> ola has quit
12:23:04 <tdxdave> tdxdave has joined #openacs
12:31:16 <tdxdave> thanks vinod!
12:41:24 <mucher> mucher has joined #openacs
12:56:09 <mucher> mucher has quit
14:35:48 <shagster> shagster has quit
14:58:26 <ola> ola has joined #openacs
15:30:04 <tdxdave> tdxdave has quit
15:38:50 <talli> talli has joined #openacs
16:04:31 <talli> talli has quit
16:10:28 <rbm> rbm has quit
16:11:51 <vinod> vinod has left channel
16:18:58 <ola> ola has quit
16:34:29 <shagster> shagster has joined #openacs
16:45:44 <PascalS> PascalS has joined #openacs
17:05:59 <Grax> Grax has joined #openacs
17:06:05 <Grax> Grax is now known as dwalker
17:15:08 <PascalS> PascalS has quit
17:34:58 <tdxdave> tdxdave has joined #openacs
17:54:23 <tdxdave> tdxdave has quit
18:07:28 <rbm> rbm has joined #openacs
18:28:12 <tdxdave> tdxdave has joined #openacs
19:33:49 <PascalS> PascalS has joined #openacs
19:34:13 <PascalS> Roberto,
19:34:27 <zzzirk> pascals: I'm actually looking for him too...
19:34:32 <PascalS> durn
19:35:13 <zzzirk> I just checked in...  I'm also checking the other place he hangs out on IRC...
19:35:22 <PascalS> Which is?
19:35:50 <zzzirk> The IRC server at Utah State University where he's studying.  Apparently he is studying for a final he has in about an hour.
19:36:13 <PascalS> hmm. I'll leave him be then.
19:36:29 <zzzirk> I'll let him know you were looking for him when I track him down.
19:36:42 <zzzirk> I'm trying to get a copy of his Oracle to PostgreSQL porting guide.
19:36:47 <PascalS> I'm going to dig into patch-submit/accept in the SDM
19:36:56 <PascalS> it's on openacs
19:37:08 <PascalS> and part op the standard Postgres (full) distro
19:37:16 <zzzirk> The one on OpenACS links to his website www.brasilero.net which I can't connect to.
19:37:30 <zzzirk> I didn't know it was part of the PostgreSQL docs.  I'll see if I can track it down there then...
19:38:16 <PascalS> check file:///usr/local/pgsql/doc/html/plpgsql-porting.html
19:38:38 <PascalS> and use the correct base dir ofcourse
19:38:39 <zzzirk> I found it on the PG site.  I'm getting ready to print it.  Thanks!
19:38:47 <zzzirk> I'm trying to do some work on the FAQ module.
19:39:06 <PascalS> 4x/
19:39:13 <PascalS> s///?/
19:39:19 <zzzirk> Yes.
19:39:33 <tdxdave> Cool.
19:40:03 <zzzirk> The company I work for has need of it (and a few other things) and I figured it looked like something fairly easy to start with and get up to speed with.
19:40:06 <PascalS> * PascalS is going to quit IRC to get some work done.
19:40:17 <zzzirk> pascals: seeya, and thanks.
19:40:24 <PascalS> PascalS has quit
19:44:19 <tdxdave> http://www.postgresql.org/idocs/index.php?plpgsql-porting.html
19:44:20 <dc_openacs> A: http://www.postgresql.org/idocs/index.php?plpgsql-porting.html from tdxdave
19:44:43 <tdxdave> A: Oracle PL/SQL to Postgresql pl/pgsql Porting Guide
19:44:43 <dc_openacs> commented item A
19:45:00 <zzzirk> Thanks tdxdave...
19:46:51 <tdxdave> np. That is blogged so hopefully people can find it.
19:47:10 <zzzirk> Where do I find the blog again?
19:47:31 <tdxdave> www.thedesignexperience.org/openacs/ircblog
19:48:10 <tdxdave> its listed in the connect message when you connect to #openacs
19:48:44 <zzzirk> I'm getting a churn.css error?
19:49:02 <tdxdave> hmmm I'll check it out.
19:49:18 <tdxdave> weird it worked for me.
19:49:28 <zzzirk> Maybe I'm doing something wrong, but I just copied and pasted from the URL you listed above...
19:49:48 <zzzirk> What are you using for logging anyway>
19:49:54 <zzzirk> s/>/?/
19:50:10 <tdxdave> The daily chump : http://usefulinc.com/chump/
19:50:34 <tdxdave> It record all URLs that are typed in. loggy logs the entire text of the channel
19:52:43 <zzzirk> Ah, ok...  
19:55:32 <tdxdave> gotta go
19:55:35 <tdxdave> tdxdave has quit
20:29:42 <talli> talli has joined #openacs
20:45:44 <andrew_s> andrew_s has quit
20:48:21 <andrew_s> andrew_s has joined #openacs
21:06:09 <talli> talli has quit
21:50:51 <tdxdave> tdxdave has joined #OpenACS
22:06:55 <zzzirk> * zzzirk is away -- Done with work -- messages will be saved.
22:12:01 <talli> talli has joined #openacs
22:12:14 <talli> talli has quit
23:07:32 <dwalker> dwalker has quit
23:28:20 <rbm> rbm has quit