Re: ORDER BY with EXCEPT?

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: "David E(dot) Wheeler" <david(at)kineticode(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: ORDER BY with EXCEPT?
Date: 2009-02-20 04:09:09
Message-ID: 499E2CE5.1010408@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2009-02-20 07:10:09 Re: GIN fast insert
Previous Message Robert Haas 2009-02-20 03:43:09 Re: GIN fast insert