Hello!

I have a very simple record

create table location (
lid serial primary key,
name varchar(128) not null,
descr text);

I'd like to retrevie for list

select lid, name, substr(descr,100) as descrbegin from location;

How should I do it with DBIx::Class? I do not want to fetch (potentially) very long description every time.

Alex.


_______________________________________________
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/[EMAIL PROTECTED]

Reply via email to