Re: How to use an hardcoded list of values

2007-10-03 Thread Manuel Vacelet
On 9/26/07, Baron Schwartz <[EMAIL PROTECTED]> wrote: > I don't think you're gaining anything by doing this though, unless it is > extremely expensive to do a lookup in item. Thanks Baron, I wanted to be sure I didn't miss a key feature. As the lookup in item is not expensive at all, I will keep

Re: How to use an hardcoded list of values

2007-09-26 Thread Baron Schwartz
Hi, Manuel Vacelet wrote: Hi all, I have a list of values I get from my application and I want to generate a record set based on this list (for an INSERT INTO ... SELECT). Today I have sth like: SELECT 54, item.item_id, mdv.valueInt FROM item i, metadata_value mdv WHERE mdv.item_id = 20202 AN

How to use an hardcoded list of values

2007-09-26 Thread Manuel Vacelet
Hi all, I have a list of values I get from my application and I want to generate a record set based on this list (for an INSERT INTO ... SELECT). Today I have sth like: SELECT 54, item.item_id, mdv.valueInt FROM item i, metadata_value mdv WHERE mdv.item_id = 20202 AND mdv.field_id = 54 AND i.ite