Duplicate data returned

От:

Vernon Wu <vernonw@gatewaytech.com>

Дата:

5 августа 2002 г. в 16:25:35


I experience a situation for the same select statement having duplicate data returned using jdbc of pgsql, while only one 
single set date returned  on the pqsl window. I need to add the "distinct" in the select statement to have a single set 
data returned.

Is the advicable practise to have the 'distinct' key word on every selection statement?

Thanks,

Vernon