> So if I understand it right, if I have a table like
> 
> Table:  ip_table
>        ip       |   ctime    |   atime
> ----------------+------------+------------
> aaa.bbb.ccc.ddd | 1234567890 | 2345678901
> eee.fff.ggg.hhh | 3456789012 | 4567890123
> 
> and I need only
> 
>     CONNECT TO localhost USER michelle.konzack;
>     RETVAL=`SELECT ctime, atime FROM ip_table WHERE ip = $SEARCH;`
> 
test=# select * from foo;
 a  | b
----+----
 10 | 10
 10 | 20

pgbash> retval=`select a,b from foo;`
pgbash> echo $retval
a | b ----+---- 10 | 10 10 | 20 (2 rows)

I remeber other project 

http://www.edlsystems.com/shellsql

bye

Pavel Stehule



---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to