GadFly - MemoryError

Oleg Broytmann phd at sun.med.ru
Wed Apr 7 10:55:30 EDT 1999


Hello!

On Wed, 7 Apr 1999, Tres Seaver wrote:
>   SELECT rec_no, URL FROM bookmarks 
>     WHERE URL IN 
>       (SELECT URL FROM bookmarks GROUP BY URL HAVING COUNT(*) > 1)
> 
> or create a temp table first with the results of the subquery, then join it in a
> separate query.

   It looks nice. I'll try.
   The problem with it is that I work with Postgres SQl server a little
more than a year, and Postgres has many problems with HAVING, so usually I
avoid it. I forget to switch my mind when switched to GadFly.
   Thanks.

> -- 
> =========================================================
> Tres Seaver         tseaver at palladion.com    713-523-6582
> Palladion Software  http://www.palladion.com
> 

Oleg.
---- 
    Oleg Broytmann  National Research Surgery Centre  http://sun.med.ru/~phd/
           Programmers don't die, they just GOSUB without RETURN.





More information about the Python-list mailing list