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