PL/PGSQL q?
1234567890
Hi!
I write function on plpgsql and have some troubles:
I have table "owe" : uid int4, date int4, cost float4;
I want to select into "owe_old" : DECLARE owe_old float4;
cur_date := date_part(''year'', now()) || ''-'' || date_part(''month'', now()) || ''-01'';
we have cur_date = '2002-05-01' for example..
And I want to :
SELECT INTO owe_old sum(cost) FROM owe WHERE date > int4(ABSTIME ''''cur_date''''');
And I have error:
NOTICE: line 24 at select into variables
ERROR: parser: parse error at or near "$1"
How I can substitute "cur_date" into SQL statement..?
Or how I can get sum(cost) in different way..?
Thank you!
--
--
Best regards, KVN.
PHP4You (<http://php4you.kiev.ua/>)
PEAR [ru] (<http://pear.php.net/manual/ru/>)
mailto:kvn@php.net