Re: ALTER TABLE ... ALTER COLUMN ... SET DISTINCT - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: ALTER TABLE ... ALTER COLUMN ... SET DISTINCT
Date
Msg-id 162867790908021055p7112e0a5t63a1ae2fac918d6c@mail.gmail.com
Whole thread Raw
In response to Re: ALTER TABLE ... ALTER COLUMN ... SET DISTINCT  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
2009/8/2 Tom Lane <tgl@sss.pgh.pa.us>:
> There wasn't any response to this comment:
>
> marcin mank <marcin.mank@gmail.com> writes:
>> ALTER COLUMN SET DISTINCT
>> feels like adding a unique constraint.
>
>> ALTER COLUMN SET STATISTICS DISTINCT ?
>> ALTER COLUMN SET STATISTICS NDISTINCT ?
>
> I don't want to add a new keyword, but "SET STATISTICS DISTINCT" would
> be an easy change.  Comments?

It's much better than SET DISTINCT.

Pavel

>
>                        regards, tom lane
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: ALTER TABLE ... ALTER COLUMN ... SET DISTINCT
Next
From: Jeff Davis
Date:
Subject: Re: Prefix support for synonym dictionary