Re: Any former bugs that loose duplicates after a sort

----- "Richard Broersma" <richard(dot)broersma(at)gmail(dot)com> wrote:

> The is someone in the MS-Access community that is seeing duplicated
> records (differing by a serial id) disappear with sorting the list by
> the unique serial id. Were there any older version of Postgres that
> did this?
>
> http://www.utteraccess.com/forums/showflat.php?Cat=&Number=1876017&page=0&view=&sb=5&o=&fpart=1&vc=1&PHPSESSID=
>
> --
> Regards,
> Richard Broersma Jr.
>

My reading of the thread is that he is seeing duplicate records that include duplicates of the serial id. The dataset is derived from a join of tables and Access queries. My guess is that the query he built is not doing what he thinks it is. This would be especially true if he used the GUI query builder, it tends to build some funky queries (especially when run against non-Jet datasources). When querying Postgres from Access I usually use pass through queries to keep Access from mucking them up to much.

Adrian Klaver
aklaver(at)comcast(dot)net