Date: Sun, 16 Mar 1997 01:06:28 -0400 (AST) From: The Hermit Hacker <scrappy@hub.org> To: hackers@freebsd.org Subject: Oracle compat stuff...*groan* Message-ID: <Pine.BSF.3.95.970316010012.205B-100000@thelab.hub.org>
next in thread | raw e-mail | index | archive | help
Hi... I just went through the trouble of compiling Edmund's 'contrib' stuff as a contrib/create function "library"...with a March 3rd server... I hate to eat crow, since it has this really really bad aftertaste that even ketchup can't cover, but...it doesn't work as reported :( If I load it up under one of the 'pre case insensitive' versions, I can use substr() or SUBSTR()...under v6.1, the case insensitive nature of v6.1 causes the server to use the last created function: test=> select * from test; str ----------- str long string (2 rows) test=> select substr(str, 3) from test; -- last created function for substr() substr --------- str ng string (2 rows) test=> select substr(str, 3, 2) from test; substr --------- str ng string (2 rows) Edmund, unless I've done something wrong (I used your oracle_compat.sql file to create the functions, these do not work the way you expected them too... So...I've been defending/trying to get to work something that doesn't seem to work as advertised :( The changes have been made to the code so that it will compile (except for Thomas's date code)... Edmund, if I have messed something up going the 'contrib' route to test things, please let me know and I'll fiddle with it some more, otherwise I need to know *which* versions of the functions are more appropriately included, and we'll need to change the man page :(
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?Pine.BSF.3.95.970316010012.205B-100000>