Polymorphic queries - Mailing list pgsql-general

From Patric Bechtel
Subject Polymorphic queries
Date
Msg-id 559AEE55.4060407@gmail.com
Whole thread Raw
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

maybe someone has an idea upon this:

I have a table which has quite a few inheriting tables which have inheriting tables etc (it's
mirroring a OOP model).

As expected, most queries are polymorphic, so they are going against the parent tables.

I'm searching for an idea how to query _once_ and, if the result hits one of the inheriting
tables, put the additional columns of them into a JSON or array structure, to avoid having to
query again to fetch the inheriting tables. I know that this would be possible with querying the
whole hierarchy via unions, but it seems extremely clumsy.

Does anyone have a solution for this or can push me in the right direction?

- --
tia,

Patric
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.22 (GNU/Linux)
Comment: GnuPT 2.5.2

iEYEARECAAYFAlWa7lUACgkQfGgGu8y7ypA5BACfY5oaQwRyvaF4QRdM2BG9Oj1p
HtMAoPNxCysjAeRAJOs5rVbqpoxRmF9M
=97f7
-----END PGP SIGNATURE-----


pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Average New Users Per DOW
Next
From: Michael Nolan
Date:
Subject: Re: Average New Users Per DOW