Search Postgresql Archives

Re: Nullsif ? PG 9.1

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





2017-04-09 20:18 GMT+12:00 Patrick B <patrickbakerbr@xxxxxxxxx>:
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.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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux