[Qgis-user] Null Values

[Charles Dixon-Paver]

 You could also pull individual values out of the array, e.g.

array_get(generate_series(10,20,1), at row_number-1)

On Sun, 16 Aug 2020 at 09:45, Alexandre Neto <senhor.neto at gmail.com> 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 <ayyalakrishna at gmail.com>
> 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
>> Qgis-user at lists.osgeo.org
>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20200816/51815dfa/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 65336 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20200816/51815dfa/attachment-0001.png>