no rows with order by

From: <jernigam_at_kochind.com>
Date: 30 Jun 2005 07:48:04 -0700
Message-ID: <1120142884.497276.223230@z14g2000cwz.googlegroups.com>

If we run the statement below

   Select prd.entry_date, prd.plant_id,

     prd.product_id, prd.unit_id,
     podcommon.gas_conv_eff(prd.plant_id, prd.entry_date,prd.unit_id)
gc_eff
        From    production prd
        Where   prd.production <> 0
        And     prd.inactive_date is null
        And     prd.product_id = 1
        And     prd.entry_date > to_date('01/01/2004','mm/dd/yyyy')

Order by prd.plant_id, prd.entry_date

We get now rows. If we remove the order by clause, we do.

Any ideas? If we remove the function, it also returns rows. Is there an issue with sorting and functions? Received on Thu Jun 30 2005 - 09:48:04 CDT