[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Gnumed-devel] gmrecalls.sql

From: Ian Haywood
Subject: Re: [Gnumed-devel] gmrecalls.sql
Date: Sat, 11 Jan 2003 19:25:34 +1100

On Fri, 10 Jan 2003 23:22:21 +1100
Ian Haywood <address@hidden> wrote:

> create view identity as select 
>       int dblink_tok (t1.ptr, 0) as id,
>       dblink_tok (t1.ptr, 1) as pupic,
>       dblink_tok (t1.ptr, 2) as gender,
>       date dblink_tok(t1.ptr, 3) as dob,
>       dblink_tok (t1.ptr, 4) as cob
> from (select dblink ((select conn from remote_dbs where 
> service='demographica'), 'select id, pupic, gender, dob, cob from identity') 
> as ptr) as t1;

I have realised this is unworkable: it would transfer the whole table just to 
find one tuple. dblink () needs to be
called each time we need it. 

See drafts/gmrules.sql for an inital example of a Python rules system.


Attachment: pgpG3YhY7YXDO.pgp
Description: PGP signature

reply via email to

[Prev in Thread] Current Thread [Next in Thread]