Re: ORDER BY with EXCEPT?

On Thu, 2009-02-19 at 17:13 -0800, David E. Wheeler wrote:
> CREATE OR REPLACE FUNCTION mytest(NAME, NAME[]) RETURNS setof text AS
> $$
> SELECT quote_ident($2[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 s.i
> $$ LANGUAGE SQL;
>

You can make it work by naming the first quote_ident like
"quote_ident($2[i]) AS foo" and then doing ORDER BY foo.

It seems a little strange to me, too, but I assume that it's SQL
standard behavior.

Regards,
Jeff Davis