problem with SELECT DISTINCT against an empty column
| От | stev knowles |
|---|---|
| Тема | problem with SELECT DISTINCT against an empty column |
| Дата | |
| Msg-id | 3.0.3.32.20020425141353.015f0e1c@pop3.norton.antivirus обсуждение исходный текст |
| Список | 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
В списке pgsql-bugs по дате отправления: