Re: ORDER BY with EXCEPT? - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: ORDER BY with EXCEPT?
Date
Msg-id 499E2CE5.1010408@dunslane.net
Whole thread Raw
In response to Re: ORDER BY with EXCEPT?  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: GIN fast insert
Next
From: Heikki Linnakangas
Date:
Subject: Re: GIN fast insert