Re: [Gnumed-bugs] a query problem when bootstrapping bundle [v18-v19-dynamic]

[Busser, Jim]

On 2013-11-17, at 12:53 PM, "Busser, Jim" <address@hidden>  wrote:

On closer examination I had misjudged the purpose of the problem query from the log which was

insert into dem.org_unit (fk_org, description)
select
(select pk from dem.org where dem.org.description = c_hs.narrative),
'unit of ' || c_hs.narrative
from
clin.hospital_stay c_hs
where
not exists (
select 1 from dem.org_unit
where
dem.org_unit.description = 'unit of ' || c_hs.narrative
and
fk_org = (select pk from dem.org where dem.org.description = c_hs.narrative)
)

which on my v18 yields

 ?column? |                 ?column?                 

----------+------------------------------------------

          | unit of Enterprise Healthcare Unit

          | unit of VGH

          | unit of Vancouver General - Med Day Care

          | unit of Vancouver General - Med Day Care

          | unit of Vancouver General Hospital

          | unit of Vanc

(6 rows)

The above is mis-stated. The output is from the query that one gets after omitting the first ("INSERT") line.

-- Jim 

signature.asc
Description: Message signed with OpenPGP using GPGMail