Dear members of the list.
I have a custom resultsource calling a db function with 4 input
parameters returning a set of rowtypes.
This resultsource is build as described in
DBIx::Class::Manual::Cookbook
Arbitrary SQL through a custom ResultSource
case a)
When I use this resultsource to get a re
my $rs=$schema->resultset('...')->search({});
my $what='not column';
$rs->update({column=>\$what});
Automagical
thx
cedric
Cedric Boudin wrote:
> Dear Members of the list,
>
> I want to do this on a table:
>
> update table set colum
Dear Members of the list,
I want to do this on a table:
update table set column=function(column) where fk=some_value;
I'm generalising here, in fact in this first case function is "not" and
column type is boolean.
I tried :
a) something inspired of "Using database functions or stored procedures
Dear list Members,
I don't want to use sequences or automatic pk generation. I create my
own specific pk's with a trigger.
Thus I thaught that just not loading the comp PK::Core in the class
definition would do the trick.
Unfortunatedly, this seems not to work.
I do get:
DBD::Pg::db last_insert_id