2017-04-09 20:18 GMT+12:00 Patrick B <patrickbake...@gmail.com>: > 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 > <(231)%20231-2312>/small/photo.jpg > > Note 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 >
Sorry guys.. Got it! https://www.postgresql.org/docs/9.1/static/functions-conditional.html
