| From: | Joe Conway <mail(at)joeconway(dot)com> |
|---|---|
| To: | David Costa <geeks(at)dotgeek(dot)org> |
| Cc: | Shridhar Daithankar <shridhar(at)frodo(dot)hserus(dot)net>, Postgresql Advocacy <pgsql-advocacy(at)postgresql(dot)org> |
| Subject: | Re: Question |
| Date: | 2004-02-21 19:25:50 |
| Message-ID: | 4037B0BE.2090203@joeconway.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-advocacy |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2004-02-21 20:41:14 | Re: plug-n-play MS SQL Server replacement |
| Previous Message | Rod Taylor | 2004-02-21 16:39:16 | [Fwd: Re: Question] |