Re: [GENERAL] Bug in my ( newbie ) mind?

[Tom Lane]

Dan Lyke <[EMAIL PROTECTED]> 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