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.
Cheers,
Csaba.