Quick Links

Compare the resulta of a count sql into bash

From:	manuel antonio ochoa <manuel8aalfaro(at)gmail(dot)com>
To:	pgsql-sql(at)postgresql(dot)org
Subject:	Compare the resulta of a count sql into bash
Date:	2011-01-26 17:07:05
Message-ID:	AANLkTikw09TZJGa8MMWPb9Rwt1_2Nom2fZjzVB8NhR+G@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-sql

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 ?

thnks

Responses

Re: Compare the resulta of a count sql into bash at 2011-01-27 04:49:53 from Josh Kupershmidt
Re: Compare the resulta of a count sql into bash at 2011-01-27 06:11:17 from Scott Marlowe
Re: Compare the resulta of a count sql into bash at 2011-01-27 10:20:06 from Jasen Betts

Browse pgsql-sql by date

	From	Date	Subject
Next Message	Craig Ringer	2011-01-27 00:11:08	Re: check files .backup
Previous Message	Oliveiros d'Azevedo Cristina	2011-01-26 17:02:33	Re: how to get row number in select query