From: | stev knowles <stev(at)Guesswork(dot)COM> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Cc: | stev(at)Guesswork(dot)Com |
Subject: | problem with SELECT DISTINCT against an empty column |
Date: | 2002-04-25 18:13:53 |
Message-ID: | 3.0.3.32.20020425141353.015f0e1c@pop3.norton.antivirus |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
i am running version 7.1.3-2 (downloaded using GNORPM) on Linux 7.2. i have
created a database, and populated the database with some rows, using a
command like:
INSERT INTO database VALUES ('','19','red');
i inserted 20 records, with different values for the second and third
column, but leaving the first column blank each time.
when i do this command:
SELECT DISTINCT Colunm FROM database ;
i get back one record, which is empty (when i print it out like this:
printf("****%s****",entry) i get ******** out.)
it looks like the "right" thing is happening, in that there is no data, or
is the lack of data considered data, if you understand what i mean?
anyway, how can i reload this database with these entries actually empty,
so that "SELECT DISTINCT" returns "PGRES_COMMAND_OK" rather than
"PGRES_TUPLES_OK"?
thanx alot. i appreciate the work you have done so far. i am sure i am
making some mistake here, but i have been all over the web site, and
haven't gotten anywhere.
i appreciate any advice you can offer.
stev knowles
From | Date | Subject | |
---|---|---|---|
Next Message | pgsql-bugs | 2002-04-25 19:25:32 | Bug #648: connection JDBC-POSTGRESQL |
Previous Message | Tom Lane | 2002-04-25 16:51:27 | Re: Bug #646: Problems inserting new records |