Bug - Mailing list pgsql-hackers

From Oleg Broytmann
Subject Bug
Date
Msg-id Pine.SOL2.3.96.SK.990917143736.19731A-100000@sun.med.ru
Whole thread Raw
Responses Re: [HACKERS] Bug
Re: [HACKERS] Bug
List pgsql-hackers
---------- Forwarded message ----------
Date: Fri, 17 Sep 1999 17:52:44 +0400 (MSD)
From: Artem Chuprina <ran@pirit.com>

ran=> create table test_source (src text);
CREATE
ran=> insert into test_source values('First distinct');
INSERT 235913 1
ran=> insert into test_source values('First distinct');
INSERT 235914 1
ran=> insert into test_source values('Second distinct');
INSERT 235915 1
ran=> insert into test_source values('Second distinct');
INSERT 235916 1
ran=> select src from test_source;
src            
---------------
First distinct 
First distinct 
Second distinct
Second distinct
(4 rows)

ran=> select distinct src from test_source;
src            
---------------
First distinct 
Second distinct
(2 rows)

ran=> create sequence seq_test;
CREATE
ran=> create table test1 (n int default nextval('seq_test'), t text);
CREATE
ran=> create table test2 (n int, t text);
CREATE
ran=> insert into test2 ("t") select distinct src from test_source;
INSERT 0 2
ran=> insert into test1 ("t") select distinct src from test_source;
INSERT 0 4        
Look here^

ran=> select * from test2;
n|t              
-+---------------|First distinct |Second distinct
(2 rows)

ran=> select * from test1;
n|t              
-+---------------
1|First distinct 
2|First distinct 
3|Second distinct
4|Second distinct
(4 rows)

PostgreSQL 6.4.2, PostgreSQL 6.5.1.

-- 
Artem Chuprina                             E-mail: ran@pirit.com
Network Administrator                        FIDO: 2:5020/371.32
PIRIT Corp.                              Phone: +7(095) 115-7101




pgsql-hackers by date:

Previous
From: Kaare Rasmussen
Date:
Subject: Hierarchical query?
Next
From: Hannu Krosing
Date:
Subject: Re: [HACKERS] Hierarchical query?