On Mon, Aug 17, 2015 at 1:15 PM, Petite Abeille <petite.abeille at gmail.com> wrote:
> > > On Aug 17, 2015, at 8:08 PM, R.Smith <rsmith at rsweb.co.za> wrote: > > > > CORRECTION: It seems one of the two options I've mentioned earlier, > namely the CREATE TABLE AS SELECT... does not actually work on the back of > a WITH clause. The other option still do, but this request has more appeal > now. > > Hmmm?!? > > create table foo as > > with > DataSet( position ) > as > ( > select 1 as position > union all > select DataSet.position + 1 as position > from DataSet > where DataSet.position < 10 > ) > select * > from DataSet; > > ?WONDERFUL! That just never entered my poor head. I guess that I was too used to the way I do it in PostgreSQL. The way things are going for me today, I feel that I'm in the lead role of "Moron Monday".? -- Schrodinger's backup: The condition of any backup is unknown until a restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown