From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | Scott Lamb <slamb(at)slamb(dot)org> |
Cc: | Postgresql General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Need feedback on new feature (\for) |
Date: | 2003-08-17 23:29:02 |
Message-ID: | 20030817232902.GA16955@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Sun, Aug 17, 2003 at 02:04:03PM -0600, Scott Lamb wrote:
> Martijn van Oosterhout wrote:
> >grant select on ":2" to ":1"
> >\for select usename, relname from pg_catalog.pg_user, pg_catalog.pg_class
> >where relname not like 'pg_%';
>
> That's definitely a useful thing to do, but I'm not sure I like your
> syntax. As someone else mentioned, the ":2" is confusing; it's like a
> bind variable, but isn't. And real bind variables don't work, as you are
> substituting identifiers, not literals.
>
> You're not completely out in the cold doing something like this without
> a patch. Right now, I believe you can do something like (in Oracle
> PL/SQL-ish syntax; it's more familiar to me):
Hmm, I didn't know you could execute pl/sql from the prompt like that.
Still, I was looking for something that was short and easy to type. Not to
mention something I can remember :)
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> "All that is needed for the forces of evil to triumph is for enough good
> men to do nothing." - Edmond Burke
> "The penalty good people pay for not being interested in politics is to be
> governed by people worse than themselves." - Plato
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-08-17 23:45:40 | Re: array concat, et al patch (was: [GENERAL] join of array) |
Previous Message | Scott Lamb | 2003-08-17 20:04:03 | Re: Need feedback on new feature (\for) |