El 22/10/11 18:10, David Johnston escribió:
>
>
> SELECT ...
> FROM vendor_invoices
> JOIN ( SELECT ... FROM eav WHERE category = '' ) icm USING ( invoice_id )
>
> Add a sub-query join for each desired category.
>
> I agree HStore looks cleaner for the query example you give. One apparent
> a
El 22/10/11 14:53, David Johnston escribió:
> On Oct 22, 2011, at 6:41, Linos wrote:
>
>> Hi all,
>>i need a little of advice on what could be the best way to store this
>> information.
>>
>> We need to calculate the difference in costs for our operation
Hi all,
i need a little of advice on what could be the best way to store this
information.
We need to calculate the difference in costs for our operations, we are already
storing our vendor invoices in the database so calculate the monetary change it
is a no-brainer but we need to store s
