> > I searched from Google and from DBIx::Recordset manual, but couldn't find > any references for using sub-selects. How is this accomplished in > Recordset? I use PostgreSQL. >
foo IN (select x from y where z = 1) could be written as Search ({'\foo' => 'IN (select x from y where z = 1)'}) ; The backslash before foo tell DBIx::Recordset to carry over the second value as it is Gerald ------------------------------------------------------------- Gerald Richter ecos electronic communication services gmbh Internetconnect * Webserver/-design/-datenbanken * Consulting Post: Tulpenstrasse 5 D-55276 Dienheim b. Mainz E-Mail: [EMAIL PROTECTED] Voice: +49 6133 925131 WWW: http://www.ecos.de Fax: +49 6133 925152 ------------------------------------------------------------- --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]