Re: [GENERAL] How to get variable out to shell script

2009-09-20 Thread Abel Camarillo
On Sun, Sep 20, 2009 at 04:49:03PM -0500, Alex Gadea wrote: > I am using psql to call an external sql file that executes a simple select > count(*): > > ie: select into ct count(*) from table; > > I can't figure out how to make the ct variable available to the shell script > once the external

Re: [GENERAL] Query

2009-05-24 Thread Abel Camarillo
On Mon, May 25, 2009 at 02:56:10AM +, marco santillan wrote: > > Hola a todos: > > Tengo la siguiente inquietud. En una consulta com la siguiente: > > select campo1, > campo2, > campo1 - campo2 as campo_virtual, > campo3, > case when campo_virtual = 1 then 5 else 0 end as segundo_campo_virtu