On Tue, Nov 24, 2009 at 09:15:43AM -0600, pphillips99@gmail.com wrote:

Stefan,

Thank you again.

I would like to use CREATE FUNCTION and have been successful with this

create function a (x int, y int) returns int return x*y;

yet I try to do more complete versions with begin/end like this (and many similar variations) without success.

create function b (x int) returns int begin declare retval int; select someval into retval from mytbl where id=x; return retval; end;

I am confused with trying to correctly learn the documentation. I searched src/tests for examples but they are only easy like my first that works.

The following files might contain some more helpful examples: ======== $ find sql -type f -name \*.sql | xargs grep -il 'create function' | xargs grep -ilw begin | xargs grep -ilw end sql/src/sql/skyserver.sql sql/src/test/BugTracker-2009/Tests/subquery_returns_table_crash.SF-2513620.sql sql/src/test/BugTracker-2009/Tests/function_call_not_handled.SF-2864179.sql sql/src/test/BugTracker-2009/Tests/coercion.sql sql/src/test/BugTracker-2009/Tests/binop.SF.2499537.sql sql/src/test/BugTracker-2009/Tests/error_while_drop_func_returns_table_type.SF-2604573.sql sql/src/test/BugTracker-2009/Tests/set_and_arg_null.SF-2812729.sql sql/src/test/function_syntax.sql sql/src/test/zones.sql sql/src/test/Via-m/create-viam.sql sql/src/test/psm.sql sql/src/test/BugTracker/Tests/decl_sec_tab_in_func_body.SF-1907858.sql sql/src/test/BugTracker/Tests/schema_from_declared_table.SF-1983341.sql sql/src/test/BugTracker/Tests/drop_function.SF-1910396.sql sql/src/test/BugTracker/Tests/sql_prepare_prob.SF-1909638.sql sql/src/test/BugTracker/Tests/table_function_column_crash.SF-1913572.sql sql/src/test/BugTracker/Tests/variable_names.SF-1838816.sql sql/src/test/BugTracker/Tests/bat_descriptor_problem.SF-1997643.sql sql/src/test/BugTracker/Tests/view_creation_using_func.SF-1714814.sql sql/src/test/BugTracker/Tests/order_by_over_table_from_another_function.SF-1959822.sql sql/src/test/BugTracker/Tests/is_not_null_syntax_error.SF-1959456.sql sql/src/test/BugTracker/Tests/orderby_in_function.SF-1892708.sql sql/src/test/BugTracker/Tests/mdb_starts_with_sql_debug_64.SF-1999354.sql sql/src/test/BugTracker/Tests/coalesce_equal_coalesce.SF-1907905.sql sql/src/test/crashme.sql sql/src/test/pg_regress/sql/triggers.sql sql/src/test/pg_regress/sql/copy2.sql sql/src/test/pg_regress/sql/portals.sql sql/src/test/pg_regress/sql/stats.sql sql/src/test/pg_regress/sql/rangefuncs.sql sql/src/test/pg_regress/sql/plpgsql.sql sql/src/test/BugTracker-2008/Tests/col_from_another_inside_function_body.SF-2420768.sql sql/src/test/Skyserver/Skyserver_functions_v6.sql sql/src/test/Skyserver/Skyserver_functions.sql sql/src/test/Triggers/triggers_schema_operations.sql sql/src/test/DropCascade/Tests/drop_table_cascade.sql sql/src/test/DropCascade/Tests/drop_function_cascade.sql sql/src/test/DropCascade/Tests/drop_view_cascade.sql sql/src/test/DropCascade/Tests/drop_columns_cascade.sql sql/src/test/BugDay_2005-10-06_2.9.3/Tests/slow_counting_1.SF-923709.sql sql/src/test/Dependencies/dependency_DBobjects.sql sql/src/test/Dependencies/dependency_functions.sql sql/src/test/bugs/Tests/select_into.sql ========

Separately, I try to read as much as possible from the website as you've said and I also read the sourceball which leads me to many things like rank() and row_number() and they seem to be working yet I don't find many of these in the website. (That was my question about Mx.)

Well, apparently, we've had time to implement these featured, but not yet to document them --- we're working on that ...

I am trying to use things I should not? At least I would like to understand create function as I can then try to make a lag ability.

See above. Feel free to post concrete questions in case you run into problems. Stefan

Thank you for you're patience. Paul

On 11/23/2009 6:35 PM, Stefan Manegold wrote:

...

Hi Paul,

Mx is only used "internally" for MonetDB development; it's not meant for let alone required by users, and hence not distributed with the MonetDB release.

All user-relevant documentation (partly indeed extracted from the Mx-based code base using Mx) should be available online on the MonetDB web site at http://www.monetdb.org/ aka. http://monetdb.cwi.nl/

Stefan

ps: In case you are indeed interested in the documentation of Mx itself, you find it at http://old-www.cwi.nl/themes/ins1/publications/docs/KeScBeBo:UNPUBLISHED:96....

pps: In case you are indeed interested in Mx itself, you find the source in the "buildtools" in the MonetDB CVS repository on SourceForge; cf., https://sourceforge.net/projects/monetdb/develop http://monetdb.cvs.sourceforge.net/viewvc/monetdb/buildtools/Mx/

On Mon, Nov 23, 2009 at 06:06:50PM -0600, Paul Phillips [ gmail ] wrote:

...

Can someone tell where the Mx utility is for creating the documentation? I have seen references in sources to this command and searches are trouble with only two letters like mx.

Is this documentation different/more than the nl website?

Thank you. Paul

------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |