Обсуждение: Any former bugs that loose duplicates after a sort
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. Visit the Los Angeles PostgreSQL Users Group (LAPUG) http://pugs.postgresql.org/lapug
----- "Richard Broersma" <richard.broersma@gmail.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 isderived 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 whenrun against non-Jet datasources). When querying Postgres from Access I usually use pass through queries to keep Accessfrom mucking them up to much. Adrian Klaver aklaver@comcast.net