Re: [SQL] MySQL-style "create temporary table foo select ..."

2004-07-21 Thread Geoff Richards
On Wed, Jul 21, 2004 at 05:07:46PM +0200, Michael Kleiser wrote: > create temporary table tmp_foo AS select * from foo; Ah, that's a relief, thanks. Just what I need. Must have missed it in the create table syntax. > Geoff Richards schrieb: > >Hi, > > > >I've

[SQL] MySQL-style "create temporary table foo select ..."

2004-07-21 Thread Geoff Richards
h the system catalog tables to get the column information in a convenient form? cheers, geoff -- Geoff Richards - GBdirect - http://development.gbdirect.co.uk/ tel: 0870 200 7273 sales: 0800 651 0338 ---(end of broadcast)--- TIP 9: the