Can user specification of a column value be required when querying a view ?

From: David Gauthier <dfgpostgres(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Can user specification of a column value be required when querying a view ?
Date: 2023-11-20 21:41:16
Message-ID: CAEs=6DmkV_hd+c9OVK4yCuedsrjO0_ZD6tnDRw5OdCC=eMh2vg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi:

I have a view that I want to require user specification for a specific
column before the query starts (if that makes sense).

Example
I want the users to be required to provide a value for ssn in the following
query...
"select * from huge_view *where ssn = '106-91-9930'* "
I never want them to query the view without specifying ssn.
It has to do with resources and practicality.

Is there a way to do that ?
Thanks

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Baldwin 2023-11-20 21:44:03 Re: Can user specification of a column value be required when querying a view ?
Previous Message Nick DeCoursin 2023-11-20 21:38:05 Re: New addition to the merge sql standard