April 2007 - users-list

[MonetDB-users] Persistent Stored Modules 'OR' operator
by Colin Foss 18 Apr '07

18 Apr '07

Is the OR operator supported in a persistent stored module? e.g. --------------------- create function tmp_myfunction(a integer) returns table (val integer) begin if a < 1 or a > 100 then return table ( select val from mytable ); else return table ( select val from another_table ); end if; end; --------------------- will return the error: ERROR = !SELECT: no such binary operator 'or(int,int)'

2 1

[MonetDB-users] ODBC
by Colin Foss 16 Apr '07

16 Apr '07

I have been trying to test ODBC with MonetDB with little success. JDBC and MapiClient are working. MS*Excel, R, and other utilities all fail while trying to initialize a connection via ODBC to MonetDB. Does anyone have a valid ODBC configuration to Monet?

4 11

[MonetDB-users] Copy command and CHAR field.
by Todd Gruben 06 Apr '07

06 Apr '07

what are valid characters that can go into the char fields? i am trying to migrate from mysql 4.1 and my data doesn't make it in. If i strip out some the the characters it makes it. The string is Cï¿½e dIvoire. which is the ivory coast. its a pain to clense, but i just wanted to know what a valid character is.

2 1

[MonetDB-users] SQL questions
by Colin Foss 05 Apr '07

05 Apr '07

1. How do you change a column's NULLable setting? I tried "alter table tmp_t alter column x set not null;" with no success. 2. How do you rename a table, short of "create table new_name like old_name;"? I tried "ALTER TABLE tmp_t RENAME TO tmp_t_new;" with no success.

1 0

[MonetDB-users] Yeah recommends
by Chaim Lonsberry 03 Apr '07

03 Apr '07

Byte PC World curtain shows http://img444.imageshack.us/my.php?image=bkqu5.gif tabs shown he

1 0

[MonetDB-users] [PF/Tijah] How to do a full text search?
by Sander Bockting 02 Apr '07

02 Apr '07

Dear all, We are trying to do a full text search in a database, but we can use some help to get started. A small excerpt from our database is stated below: //=== xquery>doc("ep") <?xml version="1.0" encoding="utf-8"?> <eprintsdata xmlns="http://eprints.org/ep2/data"> <record> <field name="eprintid">629</field> <field name="keywords">Model-based on-the-fly Testing, Timed Automata, Real-Time Testing, TorX, Tools.</field> <field name="research_projects">STRESS: Systematic Testing of Real-time Software Systems</field> </record> <record> <field name="eprintid">642</field> <field name="keywords">Compositional modelling, supervisory control</field> <field name="research_projects">HYBRIDGE: Distributed Control and Stochastic Analysis of Hybrid Systems Supporting Safety Critical Real-Time Systems Design</field> </record> </eprintsdata> //=== The PF/Tijah Getting Started page (http://dbappl.cs.utwente.nl/pftijah/Documentation/GettingStarted) mentions we can do a full text query as follows: let $c := collection("MyCollection") for $res in tijah:query($c, "//html[about(., ir db)]") return $res/head/title I believe this way is probably outdated, as tijah:query does not work. To suit our needs, I changed the query to the following form: //=== let $c := collection("ep") for $res in pf:tijah-query($c,"//field[@name='research_projects'][about(., Distributed)]") return $res //=== But this results in the following error: "ERROR = !ERROR: interpret: unknown variable 'collName'" That is why I incorporated the collection name in the query, like this: //=== for $res in pf:tijah-query(ep,"//field[@name='research_projects'][about(., Distributed)]") return $res //=== However, this also does not work, as I get the following error: "ERROR = !illegal reference to context node: at (1,29-1,30): ``.'' is unbound" I have tried numerous of other variations, but neither of them work. Can somebody please help us with an explanation about how we can do a full text search within a certain node or point us at a more recent getting started page (if it already exists)? Kind regards, Sander Bockting

2 2