Horton

Re: Bug in my ( newbie ) mind?

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Dan Lyke <danlyke@flutterby.com>
Cc: Christopher Sawtell <csawtell@xtra.co.nz>, PostgreSQL-General <pgsql-general@postgresql.org>
Date: 2001-02-21T06:33:01Z
Lists: pgsql-general 
Dan Lyke <danlyke@flutterby.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