[Aubit4gl-discuss] outer join w/ postgresql

[Bernard M. <mo...@ro...>]

I saw Marko's post to the developer list today, but I think I'm not
subscribed to that list, so I hope he may see this.

  # This is a work-around for the current lack of a proper use of "outer".
  # It was documented for Postgres sometime prior to v7.3
  # when outer joins were not yet implemented,
  # but I can't find that documentation now that the PG web pages have been
revised

  # A proper outer join syntax is much to be preferred,
  # but this will do the job, and is transportable between different
database engines

  # I prefer to avoid sql/end sql and PREPAREing,
  # since they are then by definition not transportable, and tie the code to
the PG engine.

  declare c1 cursor for
        select tableA.*,tableB.name from tableA,tableB
            where tableB.fld1=tableA.fld1
            and   fld2=VALUE
        UNION ALL
        select tableA.*,' ' from tableA
            where fld2=VALUE and fld1 not in (select fld1 from tableB)
        order by <field_list>


I look forward to a proper provision in the SQL conversion routines!

Bernard Moreton



-- 
Internal Virus Database is out-of-date.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 266.1.0 - Release Date: 18/02/2005