Re: [Zope] ZSQL: postgres, SELECT INTO
+---[ Steve Drees ]-- | Has anybody selectively used SELECT INTO with zope/postgres? It's probably dying because there can only be ONE SELECT clause in a ZSQL Method. The SELECT ... INTO will be triggering a false positive. -- Totally Holistic Enterprises Internet| P:+61 7 3870 0066 | Andrew Milton The Internet (Aust) Pty Ltd | F:+61 7 3870 4477 | ACN: 082 081 472 ABN: 83 082 081 472 | M:+61 416 022 411 | Carpe Daemon PO Box 837 Indooroopilly QLD 4068|[EMAIL PROTECTED]| ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
RE: [Zope] ZSQL: postgres, SELECT INTO
> > Has anybody selectively used SELECT INTO with zope/postgres? Make that succesfully. > > Zope version: Zope 2.1.6 (binary release, python 1.5.2, linux2-x86) > Python version: 1.5.2 (#10, Dec 6 1999, 12:16:27) [GCC 2.7.2.3] > System Platform: linux2 > ZPyGreSQLDA-0-0-3 > > > > I'm trying something like: > > SELECT DISTINCT > song, ipadress, date > INTO > TEMP d_requests > FROM > requests > WHERE > date > > > SELECT > COUNT(*) AS num_requests, > song > FROM > d_requests > GROUP BY > song > > - > works fine under psql > zope raises an exceptions.ValueError > and the db connection dies. > > > traceback follows: > > > > ___ > Zope maillist - [EMAIL PROTECTED] > http://lists.zope.org/mailman/listinfo/zope > ** No cross posts or HTML encoding! ** > (Related lists - > http://lists.zope.org/mailman/listinfo/zope-announce > http://lists.zope.org/mailman/listinfo/zope-dev ) > ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
[Zope] ZSQL: postgres, SELECT INTO
Has anybody selectively used SELECT INTO with zope/postgres? Zope version: Zope 2.1.6 (binary release, python 1.5.2, linux2-x86) Python version: 1.5.2 (#10, Dec 6 1999, 12:16:27) [GCC 2.7.2.3] System Platform: linux2 ZPyGreSQLDA-0-0-3 I'm trying something like: SELECT DISTINCT song, ipadress, date INTO TEMP d_requests FROM requests WHERE date > SELECT COUNT(*) AS num_requests, song FROM d_requests GROUP BY song - works fine under psql zope raises an exceptions.ValueError and the db connection dies. traceback follows: ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )