Thursday, 2011-08-11

*** stliu has joined #ingres04:26
*** cytrinox_ has joined #ingres05:19
*** cytrinox has quit IRC05:22
*** cytrinox_ is now known as cytrinox05:22
*** Alex| has joined #ingres06:32
*** ChanServ sets mode: +o Alex|06:32
*** Mud has joined #ingres06:52
*** Mud is now known as Guest6184806:52
*** Alex| has quit IRC07:05
*** Guest61848 has quit IRC07:17
*** Guest61848 has joined #ingres07:22
*** Alex| has joined #ingres07:23
*** ChanServ sets mode: +o Alex|07:23
Dejanmorning08:07
*** Dejan has quit IRC08:22
*** KermitTheFragger has joined #ingres09:16
*** Dejan has joined #ingres09:28
*** Dejan has quit IRC10:52
*** stliu has quit IRC11:10
*** Guest61848 has quit IRC11:17
*** Mud has joined #ingres11:22
*** Mud is now known as Guest5659511:23
pboroargh13:27
pborohow in the hell do I COPY TABLE without ingres adding padding to the column values13:27
Vroomfondleuse a format which begins with 'c0'?13:29
Vroomfondlec0nl, c0comma etc13:29
Vroomfondlefairly sure that doesn't add padding13:29
pboroI'll try that, thanks13:29
pborohmmh... I guess c0 is short for char(0)?13:31
pboro"Stored as fixed-length strings (padded with blanks if necessary). For character data, the length of the string written to the file is the same as the column length."13:31
Vroomfondleah, hrm13:31
VroomfondleI think it is short for that, yes13:32
pboroI'll go have a lunch and return to ponder this later... maybe I'll just do foo || '%' || bar || '%' || ... in CREATE TABLE tmp AS and then copy that13:32
pboroor something. :D ->13:32
Vroomfondlepersonally I'd just do the COPY TABLE and then mung the file in a script, but yeah... that way might work too ;)13:33
*** Guest56595 has quit IRC15:17
*** Mud has joined #ingres15:22
*** Mud is now known as Guest4817315:23
*** Alex| has quit IRC15:44
*** Alex| has joined #ingres16:21
*** ChanServ sets mode: +o Alex|16:21
*** DerMeister has joined #ingres17:43
*** Guest48173 has quit IRC17:58
*** Mud has joined #ingres18:00
*** Mud is now known as Guest7467118:00
*** Alex| has quit IRC18:16
*** KermitTheFragger has quit IRC18:40
*** Guest74671 has quit IRC19:17
*** Mud has joined #ingres19:21
*** DerMeister has quit IRC22:11
*** Mud has quit IRC23:04

Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!