On Thu, Oct 11, 2012 at 2:07 PM, A.M. <agentm@xxxxxxxxxxxxxxxxxxxxx> wrote:
> On Oct 11, 2012, at 4:48 PM, Ken Tanzer wrote:
> select * from generate_series(1,10) order by coalesce('foo');
Another workaround is
select bar.* from generate_series(1,3) as bar, (values ('foo')) as foo
order by foo;
or even simpler
select * from generate_series(1,3) order by (values ('foo'));
or my favorite
select * from generate_series(1,3) order by 'foo'::text;
--
Sergey Konoplev
a database and software architect
http://www.linkedin.com/in/grayhemp
Jabber: gray.ru@xxxxxxxxx Skype: gray-hemp Phone: +14158679984
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
