Andreas wrote:
> Why can['t] we use INDEX the same way as UNIQUE ?
> Perhaps even as in
> ...
> numba INT4NOT NULLINDEX
> ...
If the choice were just index or no index, then this might be ok, but
when you create an index you can choose the index type, the operator
class, a partial in
On Wednesday 07 January 2004 17:09, Andreas wrote:
> Hi,
>
> I'm moving from MySQL to Pg.
> MySQL lets me create indices like this:
>
> CREATE TABLE t (
> id INTEGERNOT NULL,
> numba INTEGER NOT NULL,
> txtVARCHAR(100) NOT NULL,
> anosanumba INTEGER
Hi,
I'm moving from MySQL to Pg.
MySQL lets me create indices like this:
CREATE TABLE t (
id INTEGERNOT NULL,
numba INTEGER NOT NULL,
txtVARCHAR(100) NOT NULL,
anosanumba INTEGER NOT NULL ,
PRIMARY KEY (id),
INDEX (numba),
UNIQUE (anosanumba)
);
