danilogarciamartins(at)hotmail(dot)com writes:
> Ex.: select regexp_split_to_array('1.2.3','.')
> returns {"","","","","",""} and not
> {1,2,3}.
This is not a bug: "." is a wild-card character in regular expressions.
You could get the behavior you're evidently after by escaping it:
# select regexp_split_to_array('1.2.3','\.');
regexp_split_to_array
-----------------------
{1,2,3}
(1 row)
regards, tom lane