Jeremy Drake wrote:
> > As for the argument about array vs setof, I could see doing both to
> > end the argument of which one is really superior for any particular
> > problem.
> regexp_split(string text, pattern text[, flags text]) returns setof
> text
> regexp_split_array(string text, pattern text[. flags text[, limit
> int]]) returns text[]

Since you are not splitting an array but returning an array, I would 
think that "regexp_split_to_array" would be better, and the other 
should then be "regexp_split_to_table".

But why does the second one have a limit and the first one doesn't?  Is 
this because you rely on the LIMIT clause to do the same?  Is there a 
guarantee that LIMIT on a table function makes a consistent order?

Peter Eisentraut

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to