Re: [dba-dev] Base functions wiki page

2007-09-04 Thread Ocke Janssen
Hi Drew, Frank Schönheit - Sun Microsystems Germany schrieb: Hi Barbara/Andrew, Looks like a *really* useful page! Have to second this! Andrew, thanks a lot! Ciao Frank Yes, very good page. :-) Drew. Best regards, Ocke PS: Even when I got some issue ;-) -- Ocke Janssen

Re: [dba-dev] Base functions wiki page

2007-09-04 Thread Frank Schönheit - Sun Microsystems Germa ny
Hi Barbara/Andrew, > Looks like a *really* useful page! Have to second this! Andrew, thanks a lot! Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base

Re: [dba-dev] Base functions wiki page

2007-09-04 Thread Barbara Duprey
Hi, Drew! andrew wrote: FYI, Went through the HSQL library source code and made a lot of updates to the wiki page: Added bitxor which was left out of the HSQL docs. Noted which functions support UNICODE and not just ASCII, and a few that ignore it. Added boundary comments to some string fu

Re: [dba-dev] Base functions wiki page

2007-09-03 Thread andrew
FYI, Went through the HSQL library source code and made a lot of updates to the wiki page: Added bitxor which was left out of the HSQL docs. Noted which functions support UNICODE and not just ASCII, and a few that ignore it. Added boundary comments to some string functions. Fixed the entry f

Re: [dba-dev] Base functions

2007-09-03 Thread andrew
Quick update - Finished the string and datetime functions ( I thought this would be faster then the aggregate functions...LOL..it was until I documented TO_CHAR [if someone is really bored you might want to double check that one] ) Drew

Re: [dba-dev] Base functions

2007-08-29 Thread Frank Schönheit - Sun Microsystems Germa ny
Hello Barbara, > Thanks for so generously considering me a collaborator, but Drew's the > one doing all the work! I'll be glad to help out however I can, though. I actually don't think so, instead I think you're en enrichment of this list already, despite being present for a short time only :)

Re: [dba-dev] Base functions

2007-08-28 Thread andrew
One more point. I did not include certain things on the page, because I am not sure if they belong here: CASE CASEWHEN OK, I think that a linked page for these makes more sense, but link off of the functions page. I don;t plan on doing that till all the entries on the current page are co

Re: [dba-dev] Base functions

2007-08-26 Thread Barbara Duprey
Frank Schönheit - Sun Microsystems Germany wrote: Hi Andrew first thanks to you and Barbary for this collaborative great work! One more point. I did not include certain things on the page, because I am not sure if they belong here: CASE CASEWHEN etx. SOME, EVERY, etc. DISTINCT LIMIT

Re: [dba-dev] Base functions

2007-08-26 Thread Frank Schönheit - Sun Microsystems Germa ny
Hi Andrew first thanks to you and Barbary for this collaborative great work! > One more point. I did not include certain things on the page, because I > am not sure if they belong here: > > CASE > CASEWHEN > etx. > > SOME, EVERY, etc. > > DISTINCT > > LIMIT > > What do others think, should

Re: [dba-dev] Base functions

2007-08-25 Thread Barbara Duprey
andrew wrote: (You can probably tell I've spent a lot of time being an editor! Picky, picky! I'd be glad to help you on this, if you'd like, or just shut up about all this petty stuff.) Hi Barbara, One of the tenants of a wiki is that the work is collaborative. For example - When edit

Re: [dba-dev] Base functions

2007-08-25 Thread andrew
(You can probably tell I've spent a lot of time being an editor! Picky, picky! I'd be glad to help you on this, if you'd like, or just shut up about all this petty stuff.) Hi Barbara, One of the tenants of a wiki is that the work is collaborative. For example - When editing a page this i

Re: [dba-dev] Base functions

2007-08-25 Thread Barbara Duprey
andrew wrote: Barbara Duprey wrote: andrew wrote: Hi, I took the liberty of adding a page to the Base area of the wiki. http://wiki.services.openoffice.org/wiki/Built-in_functions_and_Stored_Procedures Also updated the spreadsheet, available at my ftp server. The function TRIM is now

Re: [dba-dev] Base functions

2007-08-25 Thread andrew
I added the opening paragraphs to the wiki page per the last email. Fixed the TRIM function entry - problem was the standard way of showing options [opt | opt | opt ] is also meaningful code to the wiki...arrrgh. Haven't dropped that Direct column yet. ( or fixed the spelling for Designer eit

Re: [dba-dev] Base functions

2007-08-25 Thread andrew
andrew wrote: Barbara Duprey wrote: andrew wrote: Hi, I took the liberty of adding a page to the Base area of the wiki. http://wiki.services.openoffice.org/wiki/Built-in_functions_and_Stored_Procedures Also updated the spreadsheet, available at my ftp server. The function TRIM is now g

Re: [dba-dev] Base functions

2007-08-25 Thread andrew
Barbara Duprey wrote: andrew wrote: Hi, I took the liberty of adding a page to the Base area of the wiki. http://wiki.services.openoffice.org/wiki/Built-in_functions_and_Stored_Procedures Also updated the spreadsheet, available at my ftp server. The function TRIM is now grouped with str

Re: [dba-dev] Base functions

2007-08-25 Thread Barbara Duprey
andrew wrote: Hi, I took the liberty of adding a page to the Base area of the wiki. http://wiki.services.openoffice.org/wiki/Built-in_functions_and_Stored_Procedures Also updated the spreadsheet, available at my ftp server. The function TRIM is now grouped with string functions, and I ad

[dba-dev] Base functions

2007-08-25 Thread andrew
Hi, I took the liberty of adding a page to the Base area of the wiki. http://wiki.services.openoffice.org/wiki/Built-in_functions_and_Stored_Procedures Also updated the spreadsheet, available at my ftp server. The function TRIM is now grouped with string functions, and I added the statistical