Re: Need feedback on new feature (\for)

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

In response to

Responses

Browse pgsql-general by date

  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)