Postgres Pro
Downloads
Home   >   mailing lists

Re: Compare the resulta of a count sql into bash - Mailing list pgsql-sql

From Scott Marlowe
Subject Re: Compare the resulta of a count sql into bash
Date
Msg-id AANLkTi=SQ+BTiOCT64w0zw-RV18RM4JBKjWwfc3tyCvr@mail.gmail.com
Whole thread Raw
In response to Compare the resulta of a count sql into bash  (manuel antonio ochoa <manuel8aalfaro@gmail.com>)
List pgsql-sql
Tree view 
On Wed, Jan 26, 2011 at 10:07 AM, manuel antonio ochoa
<manuel8aalfaro@gmail.com> wrote:
>
> Hello,
> I have the next :
>
> COUNTONE=`/var/lib/pgsql/bin/./psql -U 'Thor'   -d princlocal -p 5432 -h
> 192.170.1.82  -c "select count(*) from monterrey.${NOMBRETB}"`
> COUNTTWO=`/var/lib/pgsql/bin/./psql -U 'Thor'   -dprinclocal -p 5432 -h
> 192.170.1.82  -c "select count(*) from monterrey.$nombre where recibo
> between '$FI' and '$FF'"
>
> I want to compare the result countone with countwo  how does it works  ?

echo $((COUNTONE-COUNTTWO));

pgsql-sql by date:

Previous
From: Josh Kupershmidt
Date:
Subject: Re: Compare the resulta of a count sql into bash
Next
From: "Santosh Bhujbal (sabhujba)"
Date:
Subject: Queyring for columns which are exist in table.