You could also pull individual values out of the array, e.g. array_get(generate_series(10,20,1),@row_number-1)
On Sun, 16 Aug 2020 at 09:45, Alexandre Neto <[email protected]> wrote: > Hello, > > The function you are using returns an Array, which does not fit a integer > field. > > I think you can achieve what you want by using something like: > > $id + 10 > > Best regards, > > Alexandre Neto > QGIS Support > www.qcooperative.net > > A domingo, 16/08/2020, 03:21, krishna Ayyala <[email protected]> > escreveu: > >> I have created a field "ID" which is an integer. I am trying to run the >> sql query as below. I am getting all "NULL" values in my "ID" field. Can >> anyone help me fix this? >> >> Regards. >> >> [image: image.png] >> _______________________________________________ >> Qgis-user mailing list >> [email protected] >> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user >> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user > > _______________________________________________ > Qgis-user mailing list > [email protected] > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________ Qgis-user mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
