have a function written in pgsql it runs just fine, except its doing
something really stupid.
The function runs just fine till this select statement
where wo_id = pWoid ;
This goes to the work order header table to gets the current value
divided by current qty thats been completed so far, then sticks the
value into _TotalCost variable based on the parameter passed into
problem is it returns NULL which is impossible as i can manually run
the select statement and get the $1.589445
I have no idea how to fix this problem going forward???
and the database is 8.3.5 running Ubuntu 8.0 lts
pgsql-general by date
|Next:||From: Karsten Hilbert||Date: 2008-12-23 21:24:14|
|Subject: encoding of PostgreSQL messages|
|Previous:||From: Dimitris Sakellarios||Date: 2008-12-23 19:30:41|
|Subject: Re: Question about pattern matching|