*** bonro011 has joined #ingres | 00:02 | |
*** bonro01 has quit IRC | 00:02 | |
*** Alex| has joined #ingres | 00:19 | |
*** ChanServ sets mode: +o Alex| | 00:19 | |
*** withdefault has joined #ingres | 00:22 | |
*** ChanServ sets mode: +o withdefault | 00:22 | |
*** KermitTheFragger has joined #ingres | 02:22 | |
*** PaulM05 has joined #ingres | 02:29 | |
*** pboro has quit IRC | 03:11 | |
*** pboro has joined #ingres | 03:12 | |
*** atrofast has joined #ingres | 03:46 | |
*** zxiiro has quit IRC | 04:42 | |
*** cthibert has joined #ingres | 04:43 | |
*** cthibert1 has joined #ingres | 04:47 | |
*** cthibert has quit IRC | 04:49 | |
*** cthibert has joined #ingres | 04:50 | |
*** cthibert1 has quit IRC | 04:51 | |
*** grantc has joined #ingres | 05:06 | |
*** Mud has joined #ingres | 05:24 | |
*** zxiiro has joined #ingres | 05:25 | |
*** ChanServ sets mode: +v zxiiro | 05:25 | |
*** rossand has joined #ingres | 05:27 | |
*** ChanServ sets mode: +o rossand | 05:27 | |
*** Mud has quit IRC | 05:29 | |
*** gerhard has joined #ingres | 05:59 | |
*** PaulM05 is now known as PaulM05_lunch | 06:00 | |
gerhard | Hi all | 06:05 |
---|---|---|
*** cthibert has left #ingres | 06:42 | |
*** PaulM05_lunch is now known as PaulM05 | 06:42 | |
*** cthibert has joined #ingres | 06:48 | |
FrankW | cthibert: I've updated with your recent commit,and I'm building it now. | 06:50 |
FrankW | I've also attempted to add my transform() stub. Perhaps I can ask a few questions later if it doesn't seem to get incorporated properly? | 06:51 |
cthibert | Great. Absolutely. | 06:51 |
FrankW | I see I *really* need the geos patches now. Grr. | 06:57 |
FrankW | Hmm, the only think coming up missing is GEOSGetX_r and GEOSGetY_r. | 06:59 |
FrankW | Is adu_geom_hilbert used for the indexing? | 06:59 |
FrankW | I'm wondering how bad it would be to just comment out these calls for now. | 06:59 |
FrankW | cthibert: any thoughts on that? | 07:00 |
cthibert | Sorry, stepped away for a sec. Yeah, hilbert is indexing. You can comment them out safely. | 07:12 |
cthibert | FrankW - to get attention to my last comment. | 07:14 |
FrankW | thanks - trying that out. | 07:15 |
FrankW | cthibert: Sweet, the build is good and my transform() function is registered and working (for now just returning the original geometry). | 07:45 |
cthibert | Excellent. Good to hear. | 07:45 |
FrankW | Would it be reasonable to commit this so my function ids and stuff are reserved, avoiding too many merge problems in the future? | 07:45 |
cthibert | Yup. Sounds like a good approach to me. | 07:46 |
FrankW | my first commit, very exciting! | 07:50 |
FrankW | Hmm, it seems I need a ticket. Should I file a ticket about the transform function? Or is there a generic ticket already for the geospatial project? | 07:51 |
cthibert | No generic ticket. We just make the tickets as required. | 07:53 |
FrankW | ok, will do. | 07:53 |
FrankW | It really isn't that easy to find the bug tracker. After looking around for a while I just took a blind stab at bugs.ingres.com and got a hit. | 07:57 |
FrankW | cthibert: how do I commit a revision against a ticket without closing it? | 08:11 |
cthibert | I've always just re-opened the ticket after submission if required. Otherwise I make another ticket, if the original ticket is specific enough. I.E. in your case the first ticket could be "Transform function stub." The second ticket - "Transform function implementation." | 08:12 |
FrankW | reopening works for me. | 08:13 |
cthibert | Perfect. | 08:13 |
*** Alex| has quit IRC | 08:21 | |
*** mull has joined #ingres | 09:15 | |
*** gerhard has left #ingres | 09:36 | |
*** Dejan has joined #ingres | 09:52 | |
Dejan | hello everybody | 09:52 |
Dejan | i have an SQL question... | 09:52 |
PaulM05 | hi | 09:52 |
Dejan | i have a table: CREATE TABLE testt(testt_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, sequence INT, someval VARCHAR(32)); | 09:52 |
Dejan | i want extract only rows that have maximum sequence | 09:52 |
Dejan | what I do atm is to make a temporary table | 09:53 |
Dejan | as i could not come with better solution | 09:53 |
Dejan | i am grouping them by someval | 09:54 |
Dejan | and in each group sequence increases... | 09:55 |
rossand | Hi All. FYI, I applied on behalf of Ingres for Google Summer of Code 2010. A list of projects are: http://community.ingres.com/wiki/GSoC If you have any project suggestions, please ping me to discuss. Thanks! | 09:56 |
rossand | No guarantees how many/if we get GSoC interns. 2008 we had 3, 2009 - 0. | 09:56 |
withdefault | dejan - within the same transaction you can use last_identity() - select * from testt where testt_id = last_identity(); | 09:57 |
Dejan | withdefault: nope, that is not the problem | 09:57 |
Dejan | an example 3 rows: (1, 1, "ITC")(2,2,"ITC")(3,3,"ITC")(4,"CPP") | 09:58 |
Dejan | 4 rows pardon | 09:59 |
Dejan | when i group this | 09:59 |
Dejan | by someval | 09:59 |
Dejan | i want only those rows with max(sequence) | 09:59 |
Dejan | in this small case i would get two rows | 09:59 |
Dejan | (3,3,"ITC")(4,1,"CPP") | 09:59 |
Dejan | i use temporary table for this, as i said, but i am sure it can be done in a more elegant way | 10:00 |
*** bonro011 has quit IRC | 10:07 | |
*** bonro01 has joined #ingres | 10:07 | |
Dejan | i think i did it | 10:28 |
Dejan | with help of an inner join | 10:28 |
*** KermitTheFragger has quit IRC | 10:51 | |
*** Alex| has joined #ingres | 11:00 | |
*** ChanServ sets mode: +o Alex| | 11:00 | |
*** PaulM05 has quit IRC | 11:38 | |
*** javahorn__ has joined #ingres | 12:08 | |
*** withdefault has quit IRC | 12:18 | |
*** cthibert has left #ingres | 12:22 | |
*** javahorn__ has quit IRC | 12:56 | |
*** zxiiro has quit IRC | 13:16 | |
*** grantc has quit IRC | 15:04 | |
*** mull has quit IRC | 15:08 | |
*** Alex| has quit IRC | 15:23 | |
*** mull has joined #ingres | 15:50 | |
*** zxiiro has joined #ingres | 15:56 | |
*** ChanServ sets mode: +v zxiiro | 15:56 | |
*** atrofast has quit IRC | 16:40 | |
*** rossand has quit IRC | 17:46 | |
*** cytrinox_ has joined #ingres | 20:20 | |
*** cytrinox has quit IRC | 20:23 | |
*** cytrinox_ is now known as cytrinox | 20:23 | |
*** Alex| has joined #ingres | 23:39 | |
*** ChanServ sets mode: +o Alex| | 23:39 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!