[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.
Ian
pgpG3YhY7YXDO.pgp
Description: PGP signature
- [Gnumed-devel] gmrecalls.sql, Horst Herb, 2003/01/09
- Re: [Gnumed-devel] gmrecalls.sql, Ian Haywood, 2003/01/10
- Re: [Gnumed-devel] gmrecalls.sql,
Ian Haywood <=
- Re: [Gnumed-devel] gmrecalls.sql, Horst Herb, 2003/01/11
- Re: [Gnumed-devel] gmrecalls.sql, Ian Haywood, 2003/01/13
- Re: [Gnumed-devel] gmrecalls.sql, Horst Herb, 2003/01/13
- Re: [Gnumed-devel] gmrecalls.sql, Ian Haywood, 2003/01/13
- Re: [Gnumed-devel] gmrecalls.sql, Karsten Hilbert, 2003/01/13
- Re: [Gnumed-devel] gmrecalls.sql, Karsten Hilbert, 2003/01/13
- Re: [Gnumed-devel] gmrecalls.sql, Karsten Hilbert, 2003/01/13
- RE: [Gnumed-devel] gmrecalls.sql, Ahammed Hashim, MD, 2003/01/13
- Re: [Gnumed-devel] gmrecalls.sql, Karsten Hilbert, 2003/01/13