Re: AW: Inserting a select statement result into another ta ble

[ Charset ISO-8859-1 unsupported, converting... ]
> 
> > > > He does ask a legitimate question though. If you are 
> > going to have a
> > > > LIMIT feature (which of course is not pure SQL), there 
> > seems no reason
> > > > you shouldn't be able to insert the result into a table.
> > > 
> > > 
> > 
> > This is an interesting idea.  We don't allow ORDER BY in 
> > INSERT INTO ...
> > SELECT because it doesn't make any sense, but it does make sense if
> > LIMIT is used:
> 
> An "order by" also makes sense if you want to create a presorted table
> for faster access. I don't see why we should disallow it.

Like CLUSTER.  I see.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026