[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