| *** zxiiro has quit IRC | 00:51 | |
| *** zxiiro has joined #ingres | 00:53 | |
| *** ChanServ sets mode: +v zxiiro | 00:53 | |
| *** grantc has joined #ingres | 01:09 | |
| *** KermitTheFragger has joined #ingres | 01:39 | |
| *** PaulM05 has joined #ingres | 02:56 | |
| grantc | Morning Vroomfondle | 03:50 |
|---|---|---|
| *** Mud has quit IRC | 03:50 | |
| *** Mud has joined #ingres | 03:56 | |
| *** cthibert has joined #ingres | 04:03 | |
| *** grantc has quit IRC | 04:19 | |
| *** grantc has joined #ingres | 04:20 | |
| *** ChanServ sets mode: +o grantc | 04:20 | |
| *** ChanServ changes topic to "This channel is logged and its archives are available @ http://irc.planetingres.org/ | Please use http://ingres.pastebin.com for pasting large (>2 lines) of text | | Please use http://ingres.pastebin.com for any code/SQL samples" | 04:21 | |
| grantc | arg | 04:21 |
| *** ChanServ changes topic to "this channel is logged and its archives are available @ http://irc.planetingres.org/ | Please use http://ingres.pastebin.com/ for pasting large (>2 lines) of text" | 04:22 | |
| *** ChanServ sets mode: -o grantc | 04:22 | |
| *** rossand has joined #ingres | 04:36 | |
| *** ChanServ sets mode: +o rossand | 04:36 | |
| *** Alex| has joined #ingres | 04:57 | |
| *** ChanServ sets mode: +o Alex| | 04:57 | |
| *** zxiiro has quit IRC | 05:05 | |
| *** PaulM05 is now known as PaulM05_lunch | 05:06 | |
| *** grantc has quit IRC | 05:07 | |
| *** grantc has joined #ingres | 05:08 | |
| *** gerhard has joined #ingres | 05:11 | |
| gerhard | Hi all | 05:11 |
| grantc | hi gerhard | 05:12 |
| *** grantc has quit IRC | 05:12 | |
| *** grantc has joined #ingres | 05:12 | |
| gerhard | Is there any "set date_format..." that will set the display format to YYYYMMDD when selecting ingresdate fields in ISQL? | 05:13 |
| grantc | ISO4 | 05:15 |
| grantc | i think | 05:15 |
| grantc | see http://ingres.pastebin.com/1ySjUdA5 | 05:17 |
| *** Alex| has quit IRC | 05:21 | |
| gerhard | Thanks! | 05:24 |
| grantc | np | 05:24 |
| *** quelgeek has quit IRC | 05:43 | |
| *** zxiiro has joined #ingres | 05:45 | |
| *** ChanServ sets mode: +v zxiiro | 05:45 | |
| *** quelgeek has joined #ingres | 05:47 | |
| *** zxiiro has quit IRC | 05:48 | |
| *** zxiiro has joined #ingres | 05:49 | |
| *** ChanServ sets mode: +v zxiiro | 05:49 | |
| *** Alex| has joined #ingres | 05:59 | |
| *** ChanServ sets mode: +o Alex| | 05:59 | |
| *** PaulM05_lunch is now known as PaulM05 | 06:04 | |
| *** Dejan has quit IRC | 06:19 | |
| *** gerhard has quit IRC | 06:22 | |
| *** gerhard has joined #ingres | 06:23 | |
| *** mull has joined #ingres | 06:58 | |
| *** Alex| has quit IRC | 07:03 | |
| *** gerhard has quit IRC | 07:09 | |
| *** quelgeek has quit IRC | 07:13 | |
| *** stliu has quit IRC | 07:23 | |
| *** Mud has quit IRC | 07:49 | |
| *** grantc has left #ingres | 07:53 | |
| *** Mud has joined #ingres | 07:56 | |
| *** Mud has quit IRC | 08:00 | |
| *** Alex| has joined #ingres | 08:37 | |
| *** ChanServ sets mode: +o Alex| | 08:37 | |
| *** zxiiro has quit IRC | 08:40 | |
| *** zxiiro has joined #ingres | 08:40 | |
| *** ChanServ sets mode: +v zxiiro | 08:40 | |
| *** KermitTheFragger has quit IRC | 09:02 | |
| *** grantc has joined #ingres | 09:02 | |
| *** ukjay has joined #ingres | 09:08 | |
| *** quelgeek has joined #ingres | 09:15 | |
| *** PaulM05 has quit IRC | 09:43 | |
| *** Mud|lalal has joined #ingres | 10:22 | |
| *** Mud2 has joined #ingres | 10:39 | |
| *** Mud2 is now known as Mud | 10:39 | |
| *** Mud|lalal has quit IRC | 10:41 | |
| *** withdefault has quit IRC | 11:30 | |
| *** quelgeek has quit IRC | 11:43 | |
| *** Mud has quit IRC | 11:50 | |
| *** Mud has joined #ingres | 11:55 | |
| *** cbain_ has joined #ingres | 12:28 | |
| *** cbain_ is now known as cbain | 12:28 | |
| *** rneves has joined #ingres | 12:31 | |
| rneves | new to ingres, anyone lend a hand? | 12:31 |
| Vroomfondle | mmm? | 12:47 |
| *** zxiiro has quit IRC | 13:00 | |
| rneves | need to trim some trailing zeros off a float i'm pulling from ingres database | 13:12 |
| rneves | is there an opensql function to do so in the query | 13:12 |
| rneves | or an openroad function to take care of it once i have it in a variable? | 13:13 |
| *** rossand has quit IRC | 13:15 | |
| *** Alex| has quit IRC | 13:19 | |
| Vroomfondle | rneves: you can't trim trailing zeros from a float whilst it remains a proper float. You could char it. | 13:19 |
| Vroomfondle | (caveat: I know nothing of OpenROAD) | 13:19 |
| rneves | yes i've converted it, even wrote a function to trim the trailing zeros, was hoping there was a better/more efficient way than the function i wrote | 13:20 |
| Vroomfondle | rneves: TRIM TRAILING '0' FROM mycolumn ? | 13:22 |
| *** cthibert has left #ingres | 13:23 | |
| Vroomfondle | still having char-ed it of course | 13:23 |
| rneves | so if i have a "select float_field from table where whatever" and wish to char and apply what you've showed me ... how would i go about doing that? can it all be done in 1 query? | 13:25 |
| rneves | thanks for your help by the way | 13:25 |
| Vroomfondle | I think: SELECT (TRIM TRAILING '0' FROM char(float_field)) as trimmed_float FROM table WHERE whatever *should* work | 13:26 |
| Vroomfondle | but I've not tried it. | 13:26 |
| Vroomfondle | this is assuming Ingres 9.2+ by the way | 13:26 |
| Vroomfondle | I'm pretty sure it didn't use to work on 2.6 | 13:26 |
| rneves | gonna give it a shot now | 13:29 |
| Vroomfondle | ah, think I messed the syntax up a bit | 13:31 |
| Vroomfondle | you may need TRIM(TRAILING '0' FROM char(float_field)) | 13:31 |
| rneves | hmmm, didnt work | 13:35 |
| rneves | if TRAILING a function? | 13:35 |
| Vroomfondle | what's the error? | 13:35 |
| Vroomfondle | the documentation suggests not | 13:36 |
| rneves | no error actualy | 13:36 |
| rneves | just didn't do it | 13:36 |
| Vroomfondle | hmm | 13:37 |
| Vroomfondle | http://docs.ingres.com/Ingres/9.2/SQL%20Reference%20Guide/stringfunctions.htm | 13:37 |
| rneves | hmmm indeed ... i'm gonna have to dig deeper to find out why this doesnt work | 13:42 |
| rneves | thanks for your help | 13:42 |
| rneves | much appreciated | 13:42 |
| Vroomfondle | no problem. Good luck. | 13:44 |
| *** quelgeek has joined #ingres | 13:58 | |
| *** rneves has quit IRC | 14:13 | |
| *** rossand has joined #ingres | 14:30 | |
| *** ChanServ sets mode: +o rossand | 14:30 | |
| *** mull has quit IRC | 15:09 | |
| *** zxiiro has joined #ingres | 15:17 | |
| *** ChanServ sets mode: +v zxiiro | 15:17 | |
| *** Mud has quit IRC | 15:49 | |
| *** Mud has joined #ingres | 15:55 | |
| *** quelgeek has quit IRC | 16:49 | |
| *** DarylM has quit IRC | 16:50 | |
| *** quelgeek has joined #ingres | 17:12 | |
| *** quelgeek has quit IRC | 17:17 | |
| *** mull has joined #ingres | 17:25 | |
| *** quelgeek has joined #ingres | 17:39 | |
| *** atrofast has quit IRC | 17:41 | |
| *** rossand has quit IRC | 17:45 | |
| *** quelgeek has quit IRC | 17:48 | |
| *** quelgeek has joined #ingres | 18:22 | |
| *** mull has quit IRC | 19:20 | |
| *** cytrinox_ has joined #ingres | 19:20 | |
| *** cytrinox has quit IRC | 19:23 | |
| *** cytrinox_ is now known as cytrinox | 19:23 | |
| *** Mud has quit IRC | 19:51 | |
| *** Mud has joined #ingres | 19:56 | |
| *** grantc has quit IRC | 20:27 | |
| *** grantc has joined #ingres | 21:28 | |
| *** Alex| has joined #ingres | 22:36 | |
| *** ChanServ sets mode: +o Alex| | 22:36 | |
| *** Alex| has quit IRC | 23:01 | |
| *** Alex| has joined #ingres | 23:18 | |
| *** ChanServ sets mode: +o Alex| | 23:18 | |
| *** quelgeek has quit IRC | 23:29 | |
| *** Mud has quit IRC | 23:50 | |
| *** quelgeek has joined #ingres | 23:50 | |
| *** Mud has joined #ingres | 23:56 | |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!