| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | manuel antonio ochoa <manuel8aalfaro(at)gmail(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Compare the resulta of a count sql into bash |
| Date: | 2011-01-27 06:11:17 |
| Message-ID: | AANLkTi=SQ+BTiOCT64w0zw-RV18RM4JBKjWwfc3tyCvr@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Wed, Jan 26, 2011 at 10:07 AM, manuel antonio ochoa
<manuel8aalfaro(at)gmail(dot)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));
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Santosh Bhujbal (sabhujba) | 2011-01-27 07:52:10 | Queyring for columns which are exist in table. |
| Previous Message | Josh Kupershmidt | 2011-01-27 04:49:53 | Re: Compare the resulta of a count sql into bash |