[Dbix-class] SELECT ... FOR UPDATE SKIP LOCKED
Francisco Obispo
francisco at obispo.link
Wed May 4 20:07:43 GMT 2016
just use the scalar version:
for
Value: ( 'update' | 'shared' | \$scalar )
Set to 'update' for a SELECT ... FOR UPDATE or 'shared' for a SELECT
... FOR SHARED. If \$scalar is passed, this is taken directly and
embedded in the query.
with
```
{
for => \q{UPDATE SKIP LOCKED}
}
```
On 4 May 2016, at 12:59, Dmitry Belyavsky wrote:
> Hello,
>
> is there a support for the PostgreSQL SELECT FOR UPDATE SKIP LOCKED clause
> in the DBIx::Class? And how difficult is to add it if not?
>
> Thank you!
>
>
> --
> SY, Dmitry Belyavsky
> _______________________________________________
> 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/20160504/940ef658/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 841 bytes
Desc: OpenPGP digital signature
URL: <http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20160504/940ef658/attachment.pgp>
More information about the DBIx-Class
mailing list