Re: no rows with order by

jernigam_at_kochind.com wrote:
> 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?

Change the ORDER BY to:

order by 2,1

and see what happens.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)