perl-embperl mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gerald Richter" <rich...@ecos.de>
Subject Re: DBIx and sub-select
Date Mon, 09 Sep 2002 06:59:27 GMT
>
> 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:     richter@ecos.de         Voice:    +49 6133 925131
WWW:        http://www.ecos.de      Fax:      +49 6133 925152
-------------------------------------------------------------



---------------------------------------------------------------------
To unsubscribe, e-mail: embperl-unsubscribe@perl.apache.org
For additional commands, e-mail: embperl-help@perl.apache.org


Mime
View raw message