Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Received-SPF: neutral (asf.osuosl.org: local policy)
Message-ID: <44FA0320.9010103@apache.org>
Date: Sat, 02 Sep 2006 15:18:08 -0700
From: Daniel John Debrunner <djd@apache.org>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
 rv:1.7.3) Gecko/20040910
MIME-Version: 1.0
To: derby-dev@db.apache.org
Subject: Re: substring/concat/curdate/curtime
References: <17657.64077.375931.514624@laura.rswheeldon.com>
In-Reply-To: <17657.64077.375931.514624@laura.rswheeldon.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

richard@rswheeldon.com wrote:

> Are these supposed to work? They're declared in the grammar,
> appear to have useful code associated with them, but none
> of them seem to do anything:

The grammer is not the definition of the functionality, the
documentation is:

All of these are the names for JDBC escape functions, introduced with
'{fn' and end with '}'.

Try this.

select {fn substring('s',2)} from simple_tab

The SQL functions for this functionality are:

SUBSTR
|| (concatenation operator)
CURRENT DATE or CURRENT_DATE
CURRENT TIME or CURRENT_TIME

http://db.apache.org/derby/docs/dev/ref/

Look at the builtin functions section.

Thanks,
Dan.


> ij> select substring('s',2) from simple_tab;
> ERROR 42X01: Syntax error: Encountered "substring" at line 1, column 8.
> ij> select substring('s',1,2) from simple_tab;
> ERROR 42X01: Syntax error: Encountered "substring" at line 1, column 8.
> ij> select concat('ab', 'cd') from simple_tab;
> ERROR 42Y03: 'CONCAT' is not recognized as a function or procedure.
> ij> select curtime() from simple_tab;
> ERROR 42Y03: 'CURDATE' is not recognized as a function or procedure.
> ij> select curtime() from simple_tab;
> ERROR 42Y03: 'CURTIME' is not recognized as a function or procedure.
> ij>