Re: [HACKERS] ORDER BY with EXCEPT?

[Andrew Dunstan]

I wrote:

select foo from (
       SELECT quote_ident($2[i]) as foo, i
         FROM generate_series(1, array_upper($2, 1)) AS s(i)
       EXCEPT
       SELECT quote_ident(p.proname)
         FROM pg_catalog.pg_proc p
         JOIN pg_catalog.pg_namespace n
           ON p.pronamespace = n.oid
          AND quote_ident(n.nspname) = quote_ident($1)
        ORDER BY i ) x;

This won't work of course.

brain malfunctioning again :-(

sorry for noise.

andrew

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers