What!  The standard is lacking?  Will wonders never cease?

Thanks, you saved me from some boring reference reading.

Still think, logically speaking, the construct should throw an error
message, rather than make stealth changes to the expected result.

Fred

-----Original Message-----
From: [email protected]
[mailto:[email protected]]on Behalf Of Igor Tandetnik
Sent: Tuesday, June 16, 2009 10:57 AM
To: [email protected]
Subject: Re: [sqlite] Datatypes (D. Richard Hipp)


Fred Williams <[email protected]>
wrote:
> Is this a violation of SQL Standards?  Seems like it should be.

As far as I can tell, CREATE TABLE AS SELECT is not part of SQL92
standard at all. If you want to work within the standard, don't use this
construct in the first place.

Igor Tandetnik



_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to