| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
Comments:
<0> buu: but then again, read the SQL cookbook
<0> and a good relational databases book
<1> postgresql.org/docs/book/
<1> or something
<2> perlbot: merlyn on mysql is http://use.perl.org/~merlyn/journal/30002
<3> added merlyn on mysql to the database
<2> amnesiac: here ^^^
<1> http://www.postgresql.org/docs/books/awbook.html
<2> amnesiac: what's up?
<1> that one is the best free book
<1> imho.
<1> I've read them all
<0> EvanCarroll: 'best' book for what?
<0> I don't believe in superlatives
<0> not even for books
<1> learning sql, thats where i started
<0> that's only for PostgreSQL
<1> I've read all of the books in english on postgresql available thats my fav to date
<1> amnesiac: It has a sql primer in it
<4> hey, where can I get all the supported math functions in perl5 and perl6?
<0> ah, that's ONLY for SQL
<1> FINE what is your point?
<0> and only SQL92 compliant, but there are more stuff
<5> Anil: perlop, perlfunc
<1> SQL is the topic.
<0> EvanCarroll: that he needs to learn real databases, so he doesn't care what syntax each Manager uses...
<6> I can open a file into an array like so:
<6> open text, @ARGV[0] or die "cannot open "+@ARGV[0];
<6> @text = <text>;
<1> alright, so you have more stuff in the spec not in the book, the spec hardly matters, only the implimentations of it
<2> EvanCarroll: I learned SQL from the MS Access 2.0 help file.
<6> so how do I open it into a variable
<1> rindolf: I woulden't say that too loud.
<0> EvanCarroll: nah, your recommendation is good, it is an SQL book
<2> EvanCarroll: until my company bought me a book about ODBC.
<1> I'm using ODBC now
<2> EvanCarroll: I'm actually quite proud of it.
<0> but that will teach him pgsql mostly ( for examples triggers/funcs in a pgsql way )
<6> if I do $text =<text> I just get the first line
<1> amnesiac: pgsql triggers are not all that different from mssql, or oracle
<5> timthelion_: So how do you get the second line?
<0> EvanCarroll: then again, JUST THOSE
<6> buu: what do you mean?
<1> amnesiac: WHAT IS YOUR POINT?
<0> they're way different than Transact SQL, and than DB2
<5> It's a simple question
<0> EvanCarroll: that learning from an implementation is NOT THE WAY to really learn
<0> that's the only point
<6> I get it by doing @text[1]
<0> timthelion_: you want $text[1]
<1> amnesiac: So what, 'insert non-existant esoteric db here' is different from those !?!?! so why read any books?!?!
<6> buu: but I don't want to use a loop to get the entire file into one string
<5> .. why?
<1> amnesiac: Sure, don't learn Linux, it is an implimentation, don't learn Windows thats an implimentation, don't learn anything just have m***ive orgies with theory fairies.
<6> buu: that would be inefficient
<5> timthelion_: Why?
<6> buu: there has to be a better way
<7> http://persistent.info/overplot/ # Brilliant!
<5> timthelion_: I'm confused. What do you think is inefficient?
<6> buu: because first you read in the entire file, then you repeatedly realokate memory to add each line together until you have the entire file in one string
<0> EvanCarroll: yeah riht
<0> right*
<5> timthelion_: Not quite.
<0> you got the point *shrug*
<5> timthelion_: It reads in block sizes.
<6> buu: why isn't there a one line method of doing this?
<5> timthelion_: Anyway, you can also undefine $./
<5> $/
<1> amnesiac: I'm resisting on the grounds of futility.
<6> what does that do?
<8> timthelion_: $str = do {local $/; <FOO> };
<5> timthelion_: See perlvar.
<1> amnesiac: becides we all know postgresql is the only db anyone needs to learn, the only other they need to polish is their ability to migrate other systems to it.
<0> buu: ask me at night so I can send you cookbook
<8> This is perl. *EVERYTHING* is one line. For sufficiently large values of 'line', natch.
<1> other skill*
<5> Mmm, toy solidars
<5> forrester forrester, dr bleeding forrester
<9> "m***ive orgies with theory fairies" sounds fun
<5> dkr: What *** are they?
<9> they haven't implemented ***
<8> It's an orgy, dude. Why does it matter?
<2> Hi all.
<2> Sorry about that, my machine got hang up.
<2> First time it happens to me in months.
<2> Maybe I ran out of memory.
<9> forget about it
<2> Hi dkr
<9> guten tag
<2> dkr: what's guten tag? Is it German?
<7> "Yeah, I know her. My sister went out with her when she was still a man."
<2> dkr: sup?
<9> yeah, for "good day"
<9> rindolf: trying not to throttle my co-workers after going over their ode, as usualy, :)
<9> code
<2> dkr: OK.
<9> their odes are ok
<2> dkr: yes, some of my (former?) co-worker's code also **** pretty badly.
<10> do arrays and hashes both have to have unique keys?
<11> Please I have to do request on a db oracle using perl. Is someone know where I can find doc ?
<2> dkr: I once spent a week or so refactoring some very nasty code.
<9> notj0hn: yes
<9> rosen37: perldoc DBD::oracle
<9> and perldoc DBI :)
<12> if I use getopt::Long do those --options get put into @ARGV?
<2> dkr: it had an INSERT and an UPDATE SQL stmts in approximately the same field ***ignment, with two completely codebases.
<10> and arrays can't have special indices ?
<11> dkr: ok thx
<2> codes, not codebases.
<2> notj0hn: if you tie them they can, I think.
<9> notj0hn: just integers, thats why they are called arrays, :)
<9> or not, :)
<2> notj0hn: but you shoould use hashes for that.
<9> I suppose you could use smoe other ordered set, like a-z
<10> ...if you say if(%blah) ... that's like saying is %blah defined, correct?
<2> notj0hn: no.
<2> notj0hn: if %blah is populated.
<9> not, if defined %blah is like saying %blah is defined
<2> notj0hn: if has any keys.
<10> omg... hmm
<10> i tried if(defined(%blah)) and i thought it said it was depricated
<9> yeah, so just check if it is populated or not
<9> not whether it is defined
<9> always trust the perldoc over us, :)
<10> if you use %blah = @_ and no params were sent into a sub what does it set %blah to?
<13> I had a if($") {next;} in my code and it can't do next on loop, the code just before that was for a login and username name field
<9> notj0hn: () an empty list
<10> k...that works
<9> or not, my brain isn't working right now, I think I had too much sugar, cookaies and coke
<10> mine isn't either because i'm trying to code perl and lack experience
<10> not to mention it's friday afternoon
<9> perl -MData::Dumper -wle'sub foo {%h=@_;print Dumper \%h}foo'
<9> $VAR1 = {};
<9> so yeah, it's just empty
<13> meant if($@)
<9> an eval was right before that?
<13> yes
<13> but it had worked before , now just says can't use next in loop
<1> I wonder how many total stories digg has
<10> textmate is on a roll today.. two updates in the same day
<14> hi Manuel
<14> they let you use the internet in prison?
<15> yeah boy'
<2> Hi Chris62vw
<2> Chris62vw: wanna read the start of my "Thoughts on Introducory Prog. Lang."?
<14> hey rindolf
<14> sure
<14> whatup kenny
Return to
#perl
or
Go to some related
logs:
#lisp
centytel
Cannot open dir Permission denied at /usr/bin/mysqlhotcopy line
ubuntu via82
turn on telnetd on ubuntu
#openzaurus
vmware ctrl-alt-f7 tty
which rpm is split-logfile in centos
#php
#php
|
|