| *** Alex| has quit IRC | 00:57 | |
| *** Alex| has joined #ingres | 00:57 | |
| *** ChanServ sets mode: +o Alex| | 00:57 | |
| *** stliu has quit IRC | 02:34 | |
| *** Dejan has joined #ingres | 03:29 | |
| Dejan | hi everyody | 03:30 |
|---|---|---|
| Dejan | everybody* | 03:30 |
| *** Dejan has quit IRC | 04:49 | |
| *** Mud has joined #ingres | 05:12 | |
| *** grantc has joined #ingres | 05:19 | |
| *** mull has quit IRC | 05:30 | |
| *** Dejan has joined #ingres | 05:57 | |
| *** mull has joined #ingres | 06:33 | |
| *** Dejan has quit IRC | 06:42 | |
| *** grassi has joined #ingres | 07:07 | |
| grassi | Hi Folks | 07:07 |
| grassi | I've got a tabel with data and want to do a query where I want all text, but no empty lines with just "\n" ... | 07:08 |
| grassi | table. | 07:08 |
| grassi | when I extract the line I don't want via python/jdbc it looks like this: | 07:09 |
| grassi | u'\n' | 07:09 |
| grassi | how do I tell the query not to pull lines with those fields from the table? | 07:09 |
| grassi | the "u" in front of the '\n' means unicode, I guess | 07:10 |
| grassi | (or utf-8) | 07:10 |
| pboro | so you want to add a WHERE part in which you restrict out rows with '\n' in the column? | 07:11 |
| grassi | select * from table where id = someid and textt <> '\n' doesn't work, unfortunately | 07:11 |
| pboro | yes, you need to use character codes, lemme browse the manual for you | 07:12 |
| grassi | muchos gracias | 07:13 |
| pboro | http://docs.ingres.com/ingres/9.2/sql-reference-guide/3667-unicode-literals | 07:13 |
| pboro | you can also work it out without using unicode, by using hexadecimal representation | 07:15 |
| pboro | http://docs.ingres.com/ingres/9.2/sql-reference-guide/2727-hexadecimal-representation | 07:15 |
| grassi | thanks, I 'll try it out shortly and see if I can get it to work... | 07:20 |
| *** mull has quit IRC | 07:28 | |
| grassi | pboro: I don't seem to be able to figure out what to write instead of " and textt <> '\n' " | 07:41 |
| pboro | lemme show you an example: | 07:41 |
| grassi | pboro: if I do : and text <> U&'Hello\1234world\+123456' I get the error Invalid syntax for Unicode literal. | 07:42 |
| grassi | that would be fantastic :-) | 07:42 |
| pboro | newline aka linefeed aka \n is 0a in hex (ascii) | 07:43 |
| pboro | so: | 07:43 |
| pboro | SELECT * FROM tbl WHERE col <> X'0a'; | 07:43 |
| pboro | that would pick all rows, where col is not '\n' | 07:44 |
| grassi | ah got it: and text <> X'0A' does the jog | 07:45 |
| grassi | job | 07:45 |
| pboro | yup :) | 07:45 |
| grassi | thank you very much | 07:46 |
| pboro | no prob | 07:46 |
| *** grassi has quit IRC | 08:05 | |
| *** Alex| has quit IRC | 08:53 | |
| *** bonsaikitten has quit IRC | 09:23 | |
| *** Alex| has joined #ingres | 09:26 | |
| *** ChanServ sets mode: +o Alex| | 09:26 | |
| *** grantc has quit IRC | 09:29 | |
| *** Alex| has quit IRC | 10:23 | |
| *** bonsaikitten has joined #ingres | 12:07 | |
| *** Mud has quit IRC | 13:28 | |
| *** clach04 has joined #ingres | 13:36 | |
| *** stliu has joined #ingres | 17:07 | |
| *** mull has joined #ingres | 20:59 | |
| *** mull has quit IRC | 21:11 | |
| *** cytrinox_ has joined #ingres | 21:16 | |
| *** mull has joined #ingres | 21:17 | |
| *** cytrinox has quit IRC | 21:19 | |
| *** cytrinox_ is now known as cytrinox | 21:19 | |
| *** Alex| has joined #ingres | 22:37 | |
| *** ChanServ sets mode: +o Alex| | 22:37 | |
| *** Alex| has quit IRC | 23:15 | |
| *** Alex| has joined #ingres | 23:38 | |
| *** ChanServ sets mode: +o Alex| | 23:38 | |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!