Hi guys,I've got this select: SELECT split_part(n.node_full_path::text, '/'::text, 8)::integer AS id,However, not always I will get the 8th field, and because of that, i may get no data somethings.Example:/filesuser/client/27801123/attachment/4510/main/filesuser/client/1111/attachment/21314134/file/12312312312/small/photo.jpgNote that, sometimes it only goes until the 7th splitted_part, not always i will get the 8th.How can I tell the select, if no 8th field is found, then returns null?Thanks!Patrick
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных