Can someone tell me how do I comapre two numbers with the decimals in UNIX shell scripting
I understand "-gt" can be used only for integers
Regards, Giri (4 Replies)
Hi All,
How we can handle decimals in (Float) in UNIX.
a=73
b=5
c=`expr a / b`
i am getting 14 but i need full 14.6 .
Can any one help me pls? (1 Reply)
I need to get 15% of the variable exer1 to be added to other exercises
so far, i've got
exer1=$1
aver=`expr $exer \* .15`
but i keep getting an error that an integer value was expected. Is there anyway around this? (1 Reply)
Hi,
I am trying to find if there is a way to convert regular decimal values to Paced decimal values. I tried to find a c program but I could get a Packed converted to regular decimal not the other way round.
If not unix please let me know if any other progrimming language I can use to do... (2 Replies)
What is the difference between test expr VS .
For example :
if test 5 -eq 6
echo "Wrong"
and
if
echo "Wrong"
bot will give the same output as Wrong.
Now, what is the difference between these two? though they are producing the same result why we need two?
Any answer will be... (2 Replies)
Hello,
I want to run a loop with non-integer values (which I know I can't) so I've created a loop of integers and divided it by 10. However, these values are always rounded down to 1 significant figure. How do I get the script to keep and use the decimal value?
My script is as follows
#... (1 Reply)
Hello...
I am new to unix and I am wondering if in a C-shell script , Are we supposed to use only whole numbers........ for example..if a program needs to calculate the average of some numbers........
@ avg = (($1 +$2 + $3)/3)) is returning a whole number.........How can a decimal be achieved... (1 Reply)
Hi All,
I would like to do the following in the shell script
561.76 to 562
I tried using this echo 'scale=0; 749 * 75 /100 ' | bc
but just returned only 561
Please help me . I appreciate your help
Thanks
rajeevm (13 Replies)
I am trying to get date to display decimal
Desired output 1350386096256.12
I know this can be done with printf, but are not able to make it work.
I have tested this and many otherprintf "%.2f" $(($(date +%s%N)/1000000)) (8 Replies)
Hi Gurus,
I have below sample file, I need find the line which 2rd field has more than 2 decimals.
in sample file, I need to find xyz, 123456.789
abc, 1234.45, def
xyz, 123456.789, xxx
bce, 1234.34, xxx
thanks in advance (13 Replies)
Discussion started by: ken6503
13 Replies
LEARN ABOUT PHP
pg_field_table
PG_FIELD_TABLE(3)PG_FIELD_TABLE(3)pg_field_table - Returns the name or oid of the tables fieldSYNOPSIS
mixed pg_field_table (resource $result, int $field_number, [bool $oid_only = false])
DESCRIPTION pg_field_table(3) returns the name of the table that field belongs to, or the table's oid if $oid_only is TRUE.
PARAMETERS
o $result
- PostgreSQL query result resource, returned by pg_query(3), pg_query_params(3) or pg_execute(3) (among others).
o $field_number
- Field number, starting from 0.
o $oid_only
- By default the tables name that field belongs to is returned but if $oid_only is set to TRUE, then the oid will instead be
returned.
RETURN VALUES
On success either the fields table name or oid. Or, FALSE on failure.
EXAMPLES
Example #1
Getting table information about a field
<?php
$dbconn = pg_connect("dbname=publisher") or die("Could not connect");
$res = pg_query($dbconn, "SELECT bar FROM foo");
echo pg_field_table($res, 0);
echo pg_field_table($res, 0, true);
$res = pg_query($dbconn, "SELECT version()");
var_dump(pg_field_table($res, 0));
?>
The above example will output something similar to:
foo
14379580
bool(false)
NOTES
Note
Returning the oid is much faster than returning the table name because fetching the table name requires a query to the database
system table.
SEE ALSO pg_field_name(3), pg_field_type(3).
PHP Documentation Group PG_FIELD_TABLE(3)