On Feb 21, 2004, at 8:25 PM, Joe Conway wrote:
> 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)
>
Wow! thanks a lot for your input and to everyone who spend some if his
valuable time on this. Eventually I opted for a simple php connection
string using Pear DB as an abstraction layer, you can see it below.
Thanks again ;)
Regards,
David Costa, PostgreSQL Advocate http://postgresql.org
david at postgresql ddoot org gurugeek att php dot net
$dsn = 'pgsql://world:most_advanced@localhost/open_source_database';