On 1/22/07, Csaba Nagy <[EMAIL PROTECTED]> wrote:
On Sat, 2007-01-20 at 18:08, Merlin Moncure wrote:
[snip]
> To be honest, I'm not a huge fan of psql tricks (error recovery being
> another example) but this could provide a solution. in your opnion,
> how would you use \if to query the transaction state?
Wouldn't it make sense to introduce instead something like:
\set language plpgsql
... and then redirect to plpgsql all you type ?
That would give you the possibility to execute things in your favorite
language directly from psql without creating a function.
The nature of pl/pgsql would make this impossible, or at least highly
complex and difficult...one reason is that the language has a much
more complex internal state than sql. Most other languages that I
think this would be worthwhile already their own immediate execution
interpreters.
merlin
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
