| *** 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!