On Mon, 2004-04-19 at 02:16, Tom Lane wrote:
> (Offhand I can't even find CREATE TABLE AS in SQL99...)
This is semi-OT, but CREATE TABLE AS is (new) in SQL2003. At few glance,
the spec's notion of the command is about the same as ours, except for a
few minor syntactic differences (e.g. the [ WITH [ NO ] DATA ] clause
the spec allows for; I'm planning to implement that soon).
-Neil
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
