Re: Question

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';




---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
     joining column's datatypes do not match