Repeat records based on field value
-----------------------------------

                 Key: CORE-4248
                 URL: http://tracker.firebirdsql.org/browse/CORE-4248
             Project: Firebird Core
          Issue Type: New Feature
            Reporter: william
            Priority: Minor


I have a table like this 

Name         Qty   
-----            -----
BD               2
SD               1
XE               3

It will be useful if I can repeat records based on the value in the Qty field 
for example first row would be repeated twice with all same values.

What I suggest to add new keyword (ex Repeat) to select statement to return the 
repeated rows like this

Select * from mytable 
Repeat On Qty
Where....




-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

------------------------------------------------------------------------------
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from 
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60135031&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to