[Dbix-class] Postgres "SELECT FROM ONLY"?

[Alex Povolotsky]

10.05.2013 21:11, Len Jaffe ?????:
> You should be able to explicitly control which columns you want to =

> select. Can you show us how you are using the SELECT FORM ONLY in the =

> SQL that you're trying to translate?

In class Record: id, fqdn
In class AddrRecord: Record and IP
In class XRecord: AddrRecord and X (field for NS or MX)
In class DistRecord: XRecord and dist (for MX)

So, I'd like to select * from only addr_record for A-type, select * from =

only x_record for NS, and select * from dist_record for MX
>
>
> On Fri, May 10, 2013 at 11:12 AM, Peter Rabbitson =

> <rabbit+dbic at rabbit.us <mailto:rabbit+dbic at rabbit.us>> wrote:
>
>     On Fri, May 10, 2013 at 05:57:27PM +0400, Alex Povolotsky wrote:
>     > Hello!
>     >
>     > Is there a way to do PG's "SELECT FROM ONLY tablename" in
>     > DBIx::Class without using literal SQL?
>     >
>
>     Sadly no. And it is unlikely to happen easily - we need the
>     Data::Query
>     transition to make this kind of stuff possible. Sorry about that.
>
>     Cheers
>
>     _______________________________________________
>     List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
>     IRC: irc.perl.org#dbix-class <http://irc.perl.org#dbix-class>
>     SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
>     Searchable Archive:
>     http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk
>
>
>
>
> -- =

> lenjaffe at jaffesystems.com <mailto:lenjaffe at jaffesystems.com> =

> 614-404-4214 www.lenjaffe.com <http://www.lenjaffe..com/>
> Proprietor: http://www.theycomewithcheese.com/ - An Homage to Fromage
> Perl Advent Planet <http://www.lenjaffe.com/PerlAdventPlanet/> - =

> Advent Calendars: Perlish and otherwise.
> Greenbar <http://www.greenbartraining.org/>: Grubmaster: 2012-2009, =

> Grub Asst: 2008, Trained: 2007.
>
>
>
> _______________________________________________
> List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
> IRC: irc.perl.org#dbix-class
> SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
> Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.=
co.uk

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20130510/b55=
f62c4/attachment.htm