Robert,
I can't help you with your performance problem, but I can help you with
CREATE TABLE AS. You've mistaken the syntax; CREATE TABLE AS does not
use column definitions other than the query. Thus, the correct syntax
should be:
> create table observationsII
> AS select o.ra, o.decl, o.mag, o.smag, o.file_id from
> observations o;
-Josh Berkus
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology [EMAIL PROTECTED]
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
