Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Adding to multiplied values



All

I've been hacking away on a little time billing database and I've been having
difficulty adding to a calculated amount. This is what I am trying to get to in an insert (for the column 'grandTotal'):

($compRate * $time) + $expenses

I've tried various combinations of quotes, double quotes, parentheses and what have you, but I still get errors like:

ERROR: operator is not unique: "unknown" + "unknown&quot and
ERROR:  invalid input syntax for type numeric: "7.50 * 5&quot

I've been able to figure out hours times comp to produce a subtotal, but I can't seem to pull in an additional amount to produce the grand total.

What's the syntax here?


thanks,

r



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group