[Dbix-class] select from dual

[mark davies]

Many thanks for the answer

Mark

On 12/07/06, Matt S Trout <dbix-class at trout.me.uk> wrote:
>
>
> On 12 Jul 2006, at 18:53, Hartmaier Alexander wrote:
>
> > Hi!
> >
> >
> >
> > If you grep through the dbic sources you can see that dbic uses raw
> > sql to do that, for example to the get last inserted id in Oracle:
> >
> >
> >
> > my $sql = "SELECT " . $seq . ".currval FROM DUAL";
> >
> > my ($id) = $self->_dbh->selectrow_array($sql);
> >
> >
> >
> > @mst: how much performance impact does the use of '' instead of ""
> > have?
>
> It doesn't. Don't be silly.
>
> --
> Matt S Trout, Technical Director, Shadowcat Systems Ltd.
> Offering custom development, consultancy and support contracts for
> Catalyst,
> DBIx::Class and BAST. Contact mst (at) shadowcatsystems.co.uk for
> details.
> + Help us build a better perl ORM: http://dbix-
> class.shadowcatsystems.co.uk/ +
>
>
>
> _______________________________________________
> List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
> Wiki: http://dbix-class.shadowcatsystems.co.uk/
> IRC: irc.perl.org#dbix-class
> SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
> Searchable Archive:
> http://www.mail-archive.com/dbix-class@lists.rawmode.org/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.rawmode.org/pipermail/dbix-class/attachments/20060713/04e8322f/attachment.htm