db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bill Robertson (JIRA)" <derby-...@db.apache.org>
Subject [jira] Created: (DERBY-1306) Support more than just varchar with vertical bars on query
Date Tue, 09 May 2006 18:30:04 GMT
Support more than just varchar with vertical bars on query

         Key: DERBY-1306
         URL: http://issues.apache.org/jira/browse/DERBY-1306
     Project: Derby
        Type: Improvement

 Environment: Relevant for this?  Windows XP
    Reporter: Bill Robertson

I'm not sure if this is ij or derby proper, but the concat operator || should work for just
about any data type.  Derby is zero maintenance, but data rarely is, and a good sql interface
is important.  Often it's very convenient to write a query that generates other sql statements
and that's difficult w/o concatination.

e.g. create a table with a timestamp column, assume that the column name is originated.

Try the following query:

ij> select month(originated) || '-' || year(originated) from review;

get the following error:

ERROR 42846: Cannot convert types 'INTEGER' to 'VARCHAR'.

The conversion to a string should pretty much work all the time unless the operand is some
sort of blob type.

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
For more information on JIRA, see:

View raw message