David Costa wrote:
> Anyone with something simple like SELECT from bestdatabases where
> logic_power.....opensource....
> something not that complicate.
> Imagine we have a table with a number of relational databases listed.
> And our query will return postgresql :D
How 'bout this:
regression=# SELECT s.a[p.i[1]] || s.a[p.i[2]] || s.a[p.i[3]] ||
s.a[p.i[4]] || s.a[p.i[5]] AS "The Best" FROM (SELECT
ARRAY['gre','S','Post',chr((ascii('X')::bit(32) #
9::bit(32))::int),'L']) AS s(a), (SELECT
string_to_array('3,1,2,4,5',',')::int[]) AS p(i);
The Best
------------
PostgreSQL
(1 row)
Joe