On Tue, Mar 13, 2001 at 03:14:00PM -0700, Casey Duncan wrote:
Lee Marzke wrote:
Hi,
I'm trying to use a subquery with the following SQL syntax and get an error.
SELECT * from return WHERE requestid = ( SELECT requestid from return ORDER BY requestid LIMIT 1 )
Each part of the queary works seperatly but not together. Are their limitation on SQL statements that are allowed ?
Using Zope 2.3.0 and PostgresSQL 7.0.3 ZPoPyDA-1.2.tar.gz PoPy-2.0.2.tar.gz
I guarantee that (some) subselects can be done with this combo of software, use them all the time. I am a bit concerned about the LIMIT clause in a subselect. Would it not be far easier to say SELECT * FROM return WHERE requestid = ( SELECT min(requestid) FROM return) ? Jim
_______________________________________________ Zope maillist - Zope@zope.org 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 )