On 1/22/07, Csaba Nagy <[EMAIL PROTECTED]> wrote:
On Sat, 2007-01-20 at 18:08, Merlin Moncure wrote:
> 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


---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at


Reply via email to