Re: Employee search question for 1.3

[John Locke <..hidden..>]

On 06/22/2011 03:26 PM, Chris Travers wrote:
> On Wed, Jun 22, 2011 at 10:12 AM, John Locke <..hidden..> wrote:
>> On 06/21/2011 04:02 PM, Chris Travers wrote:
>>> Hi John;
>>>
>>> In terms of the duplication issue can you:
>>>
>>> SELECT p.id as person_id, e.id as entity_id
>>>   FROM person p
>>>   JOIN   entity e ON (e.id = p.entity_id)
>>>  order by p.id;
>>>
>> db=> SELECT p.id as person_id, e.id as entity_id
>> db->   FROM person p
>> db->   JOIN   entity e ON (e.id = p.entity_id)
>> db->  order by p.id;
>>  person_id | entity_id
>> -----------+-----------
>>         1 |         1
>>         3 |       653
>>         4 |       654
>>         5 |       667
>> (4 rows)
>>
> And are you only seeing four rows total in the report?
>

Nope, I'm getting 7 rows.

Haven't looked yet for an overloaded function... will do that when I get
a chance and report back...

Cheers,
John Locke
http://freelock.com