On Mon, 13 Jun 2005 10:12:38 -0300, Mauro Delfino <[EMAIL PROTECTED]> wrote:
> > > I have the these two tables:
> > > CREATE TABLE table_one
> > > ( field1 VARCHAR(255) );
> > >
> > > CREATE TABLE table_two
> > > ( field1 VARCHAR(255) UNIQUE );
> > >
> > > SELECT DISTINCT field1 FROM table_one;
> >
Yes I'm sure. I was created right before filling it.
Thanks,
Mauro
2005/6/3, Bruno Wolff III <[EMAIL PROTECTED]>:
On Thu, Jun 02, 2005 at 20:22:07 +0100,Mauro Delfino <[EMAIL PROTECTED]
> wrote:>> I have the these two tables:> CREATE TABLE table_one> ( field1 VARCHAR(255) );>> CREATE TABLE table_t
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Bruno Wolff III
> Sent: Friday, June 03, 2005 11:58 PM
> To: Mauro Delfino
> Cc: pgsql-bugs@postgresql.org
> Subject: Re: [BUGS] BUG #1698: Different behavior in UNIQUE
>
On Thu, Jun 02, 2005 at 20:22:07 +0100,
Mauro Delfino <[EMAIL PROTECTED]> wrote:
>
> I have the these two tables:
> CREATE TABLE table_one
> ( field1 VARCHAR(255) );
>
> CREATE TABLE table_two
> ( field1 VARCHAR(255) UNIQUE );
>
> table_one has 500k records. I certify that all strings are dist
The following bug has been logged online:
Bug reference: 1698
Logged by: Mauro Delfino
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.4.6 and 8.0.3
Operating system: Debian and Windows 2003 Server
Description:Different behavior in UNIQUE and DISTINCT
Details:
