On 08/14/12 7:18 AM, Dmitriy Igrishin wrote:
Hey all, Is there way to determine a table column referenced by a view column via SQL? I want to create an universal function to determine mandatoriness of some column of the view (i.e. check the not null constraint of underlying table column).
note that a view column can be the result of a function or operation, perhaps on fields of several columns from several tables being joined in the view. how would your function cope with something like this?
-- john r pierce N 37, W 122 santa cruz ca mid-left coast -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
