Issue Details (XML | Word | Printable)

Key: CORE-1453
Type: Improvement Improvement
Status: Closed Closed
Resolution: Fixed
Priority: Minor Minor
Assignee: Adriano dos Santos Fernandes
Reporter: Poul Dige
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Allow usage of functions in LIST delimiter parameter

Created: 12/Sep/07 07:13 AM   Updated: 23/Jun/11 11:38 AM
Component/s: Engine
Affects Version/s: 2.1 Beta 1, 2.1.4
Fix Version/s: 2.5 Alpha 1

Time Tracking:
Not Specified

Issue Links:
Duplicate
 
Relate
 

Development: Finished


 Description  « Hide
In the LIST function it would be codewise nice to be able to use ASCII_CHAR as separator, e.g. in connection with creating a comment list like

SELECT discussion_id, LIST( comment, ASCII_CHAR(13) )
from tcomments
group by discussion_id

As it is now, you can acheive the same functionality by using

SELECT discussion_id, LIST( comment || ASCII_CHAR(13) , '' )
from tcomments
group by discussion_id



 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.