"Jim C." <[EMAIL PROTECTED]> writes:
> I've a postgres statement that reads:
> CREATE TABLE "channel" (
> "chanid" int NOT NULL default '0',
> "channum" varchar(10) NOT NULL default '',
> "freqid" varchar(10) default NULL,
> "sourceid" int default NULL,
> .
> .
> .
> PRIMARY KEY ("chanid"),
> KEY "channel_src" ("channum","sourceid")
> );
That's not Postgres, and it's not SQL either ... it's a MySQL-ism.
Use a separate CREATE INDEX statement.
> Where can I find good examples of postgres syntax?
In the manual?
http://www.postgresql.org/docs/8.2/interactive/index.html
(adjust URL to match your PG version)
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
