On Fri, 2007-02-23 at 19:25 +0100, Stefan Becker wrote:
> dear SQL friends,
>
> What I want to do might be done differantly. Right now I can't
> think of another solution other than a select statement
>
> I would like to create a sequence range of integer constants. Join
> this sequence against
On Fri, 2007-02-23 at 12:25, Stefan Becker wrote:
> dear SQL friends,
>
> What I want to do might be done differantly. Right now I can't
> think of another solution other than a select statement
>
> I would like to create a sequence range of integer constants. Join
> this sequence against a ID
am Fri, dem 23.02.2007, um 19:25:35 +0100 mailte Stefan Becker folgendes:
> Now: Is there a syntax that allows for the following.
>
> create table XX (id int);
> insert into XX (select xx from "1 to 1000" of integers)
Perhaps you are searching for generate_series():
test=*# select generat
dear SQL friends,
What I want to do might be done differantly. Right now I can't
think of another solution other than a select statement
I would like to create a sequence range of integer constants. Join
this sequence against a ID Range in a database and look for missing
Id's.
Another appli