>
> 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]

Reply via email to