Re: DBI: select distinct returns same values

[erix]

The only important column from this table is the datestamp column called date.

Data type 'datestamp' does not exist in PostgreSQL. What's the data type of column 'record_date'? (try \d itens.lbd_w300 in psql)

[tukusejssirs]

By datestamp I meant timestamp. ;)

And I tried to use general names for db/schema/table, but have missed some of them. I have just modified the OP to make it more consistent.

To answer your question: the date/record_date column is of timestamp type.

[erix]

I can't get your results. In my hands, I get the distinct values, as expected, also with that little chunk of perl code of yours. If I remove the 'DISTINCT' I get the doubles (I made a 4 row table).

So you must be overlooking some detail. Maybe you can write up a small but complete) code example (including data) with data (!) that can be run against a postgres database (remove/change the user/password, of course). I expect that while you prepare that, you will see what went wrong.

(by the way: the Pg don't-do-this page advises against this data type )

edit: I was mistaken; I probably futzed my own try-out code, but I see you got good answers already so I'll leave it at that.

[AnomalousMonk]

I have just modified the OP ...

Please see How do I change/delete my post? for site etiquette and protocol regarding such changes. Bottom line: Do Not Destroy Context!