seil...@so-net.net.tw writes:
> I need to know the match columns of referencing and referenced keys.
The query you show definitely won't match them up correctly, since that
=ANY test is not order-sensitive. What you need to do is generate the
integers from 1 to array_length(conkey) and then join on attnum =
conkey[i], rather than using =ANY. You can find some examples in the
information_schema views. (In fact, you might well find that the
information_schema views are close enough already to what you need.)
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
