*** zxiiro has quit IRC | 00:20 | |
*** atrofast has quit IRC | 00:21 | |
*** zxiiro has joined #ingres | 00:23 | |
*** ChanServ sets mode: +v zxiiro | 00:23 | |
*** Mud has joined #ingres | 00:26 | |
*** atrofast has joined #ingres | 00:29 | |
*** Gerhard has joined #ingres | 00:53 | |
Gerhard | Hi all | 00:54 |
---|---|---|
*** grassi has joined #ingres | 01:02 | |
grassi | Hi there, I have a SQL question which I currently can't figure out myself by reading the fabulous manual. | 01:06 |
grassi | I want to do something like: | 01:06 |
grassi | SELECT | 01:06 |
grassi | CASE WHEN last_buy < '2008.10.1' THEN '#'+customer_nr) ELSE customer_nr END as "customer code" | 01:06 |
grassi | FROM customer_table | 01:06 |
grassi | So when a customer hasn't bought anything since Oct. 2008, the customer_nr gets a '#' added as a prefix... Is that possible? | 01:06 |
*** KermitTheFragger has joined #ingres | 01:10 | |
*** grantc has joined #ingres | 01:25 | |
grantc | morning all | 01:25 |
Gerhard | I have a customer that from time to time accidentally produces carthesian products over huge tables leading to enormous work files and crashing the DBMS. Any chance to "auto-abort" those SQLs? | 01:40 |
Gerhard | I suppose that cause of the carthesian products are ill-designed VDBA queries, Excel / ODBC, Crystal Reports... | 01:44 |
grantc | Gerhard: you can set io limits for queries | 02:10 |
Gerhard | in CBF? | 02:11 |
grantc | see http://docs.ingres.com/ingres/10.0/sql-reference-guide/1260-nomaxrow | 02:12 |
Gerhard | Thanks for the link. Must I set this with ingsetenv ING_SET .... on the clients? | 02:14 |
Gerhard | ah, I see this can be defined in a central place: http://docs.ingres.com/ingres/9.2/security-guide/4846-database-grant-examples | 02:16 |
*** stliu has quit IRC | 02:19 | |
*** cthibert has joined #ingres | 04:57 | |
*** Gerhard has quit IRC | 05:17 | |
*** cthibert has left #ingres | 05:27 | |
*** mull has quit IRC | 05:33 | |
*** cthibert has joined #ingres | 05:34 | |
*** zxiiro has quit IRC | 06:09 | |
*** atrofast has quit IRC | 06:09 | |
*** atrofast has joined #ingres | 06:11 | |
*** zxiiro has joined #ingres | 06:12 | |
*** ChanServ sets mode: +v zxiiro | 06:12 | |
*** mull has joined #ingres | 06:18 | |
*** cthibert has left #ingres | 07:16 | |
*** cthibert has joined #ingres | 07:17 | |
*** grassi has quit IRC | 08:45 | |
*** Mud has quit IRC | 09:43 | |
*** grantc has quit IRC | 09:45 | |
*** Mud has joined #ingres | 09:47 | |
*** weta has quit IRC | 10:05 | |
*** weta has joined #ingres | 10:12 | |
*** KermitTheFragger has quit IRC | 10:17 | |
*** cytrinox_ has joined #ingres | 10:22 | |
*** cytrinox has quit IRC | 10:26 | |
*** cytrinox_ is now known as cytrinox | 10:26 | |
*** stliu has joined #ingres | 11:26 | |
*** weta has quit IRC | 12:00 | |
*** weta has joined #ingres | 12:00 | |
*** Alex| has joined #ingres | 12:44 | |
*** ChanServ sets mode: +o Alex| | 12:44 | |
*** DerMeister has joined #ingres | 13:24 | |
*** Alex| has quit IRC | 13:48 | |
*** DerMeister has quit IRC | 14:03 | |
*** Mud has quit IRC | 14:10 | |
*** cthibert1 has joined #ingres | 15:18 | |
*** cthibert1 has left #ingres | 15:19 | |
*** cthibert has quit IRC | 15:20 | |
*** toumi01 has quit IRC | 15:23 | |
*** mull has quit IRC | 16:02 | |
*** mull has joined #ingres | 16:57 | |
*** mull has quit IRC | 19:37 | |
*** stliu has quit IRC | 20:13 | |
*** stliu has joined #ingres | 20:45 | |
*** cytrinox_ has joined #ingres | 21:04 | |
*** stliu has joined #ingres | 21:07 | |
*** stliu has joined #ingres | 21:07 | |
*** cytrinox has quit IRC | 21:08 | |
*** cytrinox_ is now known as cytrinox | 21:08 | |
*** Alex| has joined #ingres | 22:22 | |
*** ChanServ sets mode: +o Alex| | 22:22 | |
*** Alex| has quit IRC | 22:55 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!