From owner-freebsd-hackers Sat Mar 15 21:08:56 1997 Return-Path: Received: (from root@localhost) by freefall.freebsd.org (8.8.5/8.8.5) id VAA08450 for hackers-outgoing; Sat, 15 Mar 1997 21:08:56 -0800 (PST) Received: from thelab.hub.org (hal-ns1-31.netcom.ca [207.181.94.95]) by freefall.freebsd.org (8.8.5/8.8.5) with ESMTP id VAA08405 for ; Sat, 15 Mar 1997 21:06:43 -0800 (PST) Received: from thelab.hub.org (LOCALHOST [127.0.0.1]) by thelab.hub.org (8.8.5/8.8.2) with SMTP id BAA05689 for ; Sun, 16 Mar 1997 01:06:28 -0400 (AST) Date: Sun, 16 Mar 1997 01:06:28 -0400 (AST) From: The Hermit Hacker To: hackers@freebsd.org Subject: Oracle compat stuff...*groan* Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-hackers@freebsd.org X-Loop: FreeBSD.org Precedence: bulk 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 :(