Hi,

As I'm trying to interface with beancount only through bean-query, I'm 
wondering if I'm doing it right to retrieve a certain price at a certain 
date.

To select a single price I'm doing this:

select distinct getprice('USD', 'CHF', #'2017-10-10')

This works but it looks like what's happening in the back is that it does 
the getprice call for each position and then only reduced it down to a 
single response because of the distinct (without the distinct I'm getting 
N-times the price.
Is there something that I'm missing? Is there something similar to the 
oracle "select from dual" to avoid this?

Thanks and Regards,
Patrick



-- 
You received this message because you are subscribed to the Google Groups 
"Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/beancount/536221c5-3b89-4bf0-abfd-a52a6d8528ef%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to