*** Alex| has quit IRC | 00:15 | |
*** PaulM05 has joined #ingres | 01:09 | |
*** raial01 has joined #ingres | 01:44 | |
*** grantc has joined #ingres | 02:43 | |
*** ChanServ sets mode: +o grantc | 02:43 | |
*** zxiiro has quit IRC | 05:05 | |
*** Dejan has joined #ingres | 05:09 | |
Dejan | hello | 05:09 |
---|---|---|
pboro | Hi Dejan | 05:10 |
*** rossand has joined #ingres | 05:10 | |
*** ChanServ sets mode: +o rossand | 05:10 | |
Dejan | guys, is there a DDS about aliases being used in WHERE statements? | 05:15 |
Dejan | it seems INGRES does not allow SELECT something AS SOM FROM some_table WHERE SOM = 'INGRES' | 05:16 |
Dejan | ORDER BY SOM works | 05:16 |
Dejan | but WHERE does not | 05:16 |
*** PaulM05 is now known as paul_at_lunch | 05:24 | |
*** cthibert has joined #ingres | 05:29 | |
atrofast | Dejan: You are correct it does not work I ran into tjhis a lot when porting Drupal :) | 05:31 |
atrofast | Unfortunately I'm not knowledgeable enough about the parser to try to make it happen :( | 05:31 |
*** atrofast has quit IRC | 05:43 | |
*** atrofast has joined #ingres | 05:44 | |
*** zxiiro has joined #ingres | 05:49 | |
*** ChanServ sets mode: +v zxiiro | 05:49 | |
Dejan | i hope it will be done in some of the future versions of INGRES | 06:46 |
Dejan | really | 06:46 |
Dejan | that is one my most wanted things in INGRES | 06:46 |
Dejan | after renaming of columns/tables | 06:47 |
Dejan | which is definitely my most wanted thing | 06:47 |
*** cthibert has left #ingres | 07:01 | |
*** Alex| has joined #ingres | 07:05 | |
*** ChanServ sets mode: +o Alex| | 07:05 | |
*** paul_at_lunch is now known as PaulM05 | 07:19 | |
*** Mud is now known as Mud|afk | 07:24 | |
*** cthibert has joined #ingres | 07:27 | |
*** Alex| has quit IRC | 07:32 | |
*** Gerhard has joined #ingres | 07:54 | |
*** ccsidiot has joined #ingres | 07:57 | |
*** Gerhard has quit IRC | 08:29 | |
raial01 | ckach04: thanks for updating that trac ticket. i'm afraid i didn't really understand what you were saying about changing the bind type | 08:36 |
raial01 | can you expand? | 08:36 |
raial01 | (for other people's benefit, the ticket was http://bugs.ingres.com/ticket/505#comment:4) | 08:38 |
grantc | raial01, i'm not sure clach04 is here since it's thanksgiving in the US today | 08:43 |
grantc | the param is being sent as a nvarchar and not a nclob/long nvarchar hence the truncation | 08:44 |
raial01 | @grantc: ok thanks - is there a way to send the param as an nclob? | 08:49 |
ii_log | raial01: Error: "grantc:" is not a valid command. | 08:49 |
raial01 | grantc: ok thanks - is there a way to send the param as an nclob? | 08:49 |
grantc | i'm browsing the source to check | 08:50 |
*** zxiiro has quit IRC | 08:50 | |
*** zxiiro has joined #ingres | 08:51 | |
*** ChanServ sets mode: +v zxiiro | 08:51 | |
grantc | are you working from the SVN source or from the last release? | 08:56 |
grantc | if from SVN you could try this patch - http://ingres.pastebin.com/f5b8dee55 | 08:58 |
grantc | otherwise look for the BindParameters function in iidbicurs.c and add the entry for SQL_WLONGVARCHAR | 08:59 |
ccsidiot | Hey everyone, sorry to disturb, the GEOS library comments in the header file/source code are not very useful, how do you guys work around with it? | 08:59 |
grantc | raial01, that patch might not work as the call to SQLBindParameter might need some changes too | 09:00 |
raial01 | grantc: ok i'm using the svn head version; i'll give that a go. my problem is that i have a java script file that's 25K characters long that I want to store in the DB! | 09:03 |
raial01 | gtg now, bye | 09:05 |
*** raial01 has quit IRC | 09:05 | |
Dejan | clear | 09:34 |
Dejan | ups | 09:34 |
*** grantc has quit IRC | 09:35 | |
*** Vroomfondle has quit IRC | 09:36 | |
cthibert | ccsidiot - What do you need? Mostly I go by the function names, as they are pretty self descriptive. There's also the geos wiki which may help. http://trac.osgeo.org/geos/ | 10:11 |
cthibert | On the wiki there is Doxygen documentation of the API. See near the bottom in Other information section. | 10:12 |
ccsidiot | I tried to go function names: GEOSWKBWriter_write_r | 10:13 |
ccsidiot | And it says /*The owner owns the results for these two methods! */ | 10:14 |
ccsidiot | LOL | 10:14 |
ccsidiot | I googled the site above too, trac.osgeos.org/geos | 10:14 |
ccsidiot | and I'm lost in how to dig into that | 10:15 |
FrankW | ccsidiot: Looking in the implementation in geos_ts_c.cpp it is clear the caller gets ownership of the returned WKB buffer and should free it with free(). | 10:23 |
FrankW | I shall attempt to clarify the notes. | 10:23 |
FrankW | Ugg, http://download.osgeo.org/geos/doxygen/c_iface.html isn't very helpful! | 10:24 |
*** Dejan has quit IRC | 10:25 | |
*** Alex| has joined #ingres | 10:26 | |
*** ChanServ sets mode: +o Alex| | 10:26 | |
cthibert | FrankW - Is it okay if I forward a question about building 32bit geos on 64bit machines to you? There's someone else trying to do it and, having not done it, I'm not sure of the details. | 10:29 |
FrankW | cthibert: win64 or 64bitlinux? | 10:30 |
cthibert | 64bit linux | 10:30 |
FrankW | I'm willing to try and field linux issues. | 10:30 |
FrankW | sure no problem. | 10:30 |
cthibert | Okay, thanks. :) | 10:30 |
FrankW | ccsidiot: http://trac.osgeo.org/geos/changeset/2742 | 10:31 |
ccsidiot | Thanks FrankW, cthibert :) So if I want to know what does a particular function in GEOS do, I will need to dig into the source code? | 10:44 |
cthibert | Also, if you look at the simple feature specification it describes the operations, which tend to match with the Geos functions names. | 10:46 |
ccsidiot | Say for example, it's not clear to me what's being done in the function other than knowing about the ownership of the result from GEOSWKBWriter_write_r | 10:46 |
ccsidiot | FrankW: Less than 1 hour ago, they've changed the comment | 10:48 |
cthibert | Ah. Yes, being familiar with the simple feature spec will help there too. That function will write a WKB stream. Well Known Binary. | 10:48 |
ccsidiot | cthibert: The simple feature spec that you are refering to is the one that you've sent me just now? | 10:48 |
cthibert | It's available from the Geos trac site I sent the link to, yes. | 10:49 |
ccsidiot | Thanks cthibert, FrankW, time to do more reading | 10:51 |
ccsidiot | :) | 10:51 |
*** zxiiro_ has joined #ingres | 11:10 | |
*** zxiiro has quit IRC | 11:10 | |
*** Alex| has quit IRC | 11:37 | |
*** Alex| has joined #ingres | 11:44 | |
*** ChanServ sets mode: +o Alex| | 11:44 | |
*** Mud|afk has quit IRC | 11:51 | |
*** atrofast has quit IRC | 12:03 | |
*** Alex| has quit IRC | 12:33 | |
*** cthibert has left #ingres | 13:15 | |
*** zxiiro_ has quit IRC | 13:34 | |
*** zxiiro has joined #ingres | 13:36 | |
*** ChanServ sets mode: +v zxiiro | 13:36 | |
*** zxiiro has quit IRC | 13:48 | |
*** ccsidiot has quit IRC | 14:28 | |
*** ccsidiot has joined #ingres | 14:30 | |
*** zxiiro has joined #ingres | 14:37 | |
*** ChanServ sets mode: +v zxiiro | 14:37 | |
*** PaulM05 has quit IRC | 14:50 | |
*** ccsidiot has quit IRC | 16:35 | |
*** ccsidiot has joined #ingres | 16:39 | |
*** rossand has quit IRC | 17:15 | |
*** withdefault1 has joined #ingres | 17:35 | |
*** thoda05 has joined #ingres | 17:50 | |
*** withdefault has quit IRC | 17:53 | |
*** thoda05 has left #ingres | 18:30 | |
*** cytrinox_ has joined #ingres | 19:20 | |
*** cytrinox has quit IRC | 19:21 | |
*** cytrinox_ is now known as cytrinox | 19:21 | |
*** rossand has joined #ingres | 19:42 | |
*** ChanServ sets mode: +o rossand | 19:42 | |
*** omega187 has joined #ingres | 20:00 | |
*** omega187 has left #ingres | 20:00 | |
*** rossand has quit IRC | 20:22 | |
*** ccsidiot has left #ingres | 20:24 | |
*** FrankW has quit IRC | 22:52 | |
*** withdefault1 has quit IRC | 23:03 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!