[firebird-support] Number list without table

Hi I need to get list of number (f.e 1,2,3,4,5) as rows but using only SQL query (without extra table or view). Something what after running query looks like: List_of_numbers --- 1 2 3 4 5 Any ideas?? Piotr [Non-text portions of this message have been

RE: [firebird-support] Number list without table

Piotr I need to get list of number (f.e 1,2,3,4,5) as rows but using only SQL query (without extra table or view). Something what after running query looks like: List_of_numbers --- 1 2 3 4 5 Any ideas?? EXECUTE BLOCK ( StartNumber Integer,

Re: [firebird-support] Number list without table

Hi Piotr, I need to get list of number (f.e 1,2,3,4,5) as rows but using only SQL query (without extra table or view). Something what after running query looks like: List_of_numbers --- 1 2 3 4 5 You can write a selectable stored procedure to achieve that, with

Re: [firebird-support] Number list without table

On Thu, Jul 25, 2013 at 8:46 PM, Piotr Olszewski piotr.olszew...@eskrzynka.pl wrote: ** I need to get list of number (f.e 1,2,3,4,5) as rows but using only SQL query (without extra table or view). Hi there, looks like Sean answered faster than me. Here's the documentation for what you