Search Postgresql Archives

plpgsql question

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I am trying to calculate a value from a current record in a query and can't seem to get it working.

Here is the shortened query;
SELECT
      s.id,
      r.the_date_time,
      s.open_price,
      s.high_price,
      s.low_price,
      s.close_price,
      thesheet_onepair.symbol,
      r.buy_long,
      r.buy_stop,
      r.sell_cl,
      r.stop_sell,
      r.sell_short,
      r.sell_stop,
      r.buy_os,
      r.stop_buy,
      check_long_profit ()as tst
      FROM
        public.thesheet_dailystats s,
        public.thesheet_recommendation r,
        public.thesheet_onepair
      WHERE
        s.one_pair_id = thesheet_onepair.id AND
        s.the_date = r.the_date_time::date AND
        r.one_pair_id = thesheet_onepair.id
      ORDER BY
        r.the_date_time DESC,
        thesheet_onepair.id ASC;


check_long_profit is the function. I basically want to do some calculations on this record and return some calculated fields.

I can't seem to figure out how to pass the row.

Here is my header for the function
create or replace function check_long_profit () returns integer AS $$

I know I am missing something easy.

Thanks



--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux