Dan Lyke <danlyke(at)flutterby(dot)com> writes:
> So one might think that, with appropriate casting, something more
> like:
> select (select phone_prefix.prefix order by random() limit 1) || ...
> would be more likely to work (modulo some casting and such).
Note this will not work in pre-7.1 releases --- 7.1 is the first that
allows ORDER BY and LIMIT clauses in a sub-select.
regards, tom lane