From: | Luca Ferrari <fluca1978(at)infinito(dot)it> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | hiding column values for specific rows |
Date: | 2006-11-13 13:11:50 |
Message-ID: | 200611131411.50562.fluca1978@infinito.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi,
I don't know if this's possible but I'd like to hide column values for
specific rows within a query. Imagine I've got a table with columns username
and password: users(username,password). Now I'd like the user registered in
the table to see her password, to see who is registered but not to see the
other people passwords. For example, if the table contains:
username | password
--------------+-------------
luca | myPaswd
roberto | otherPaswd
gianna | thirdPaswd
I'd like to do a query like: "SELECT * FROM users where username=luca"
obtaining something like:
username | password
--------------+-------------
luca | myPaswd
roberto | xxxxx
gianna | XXXXX
Is it possible to specify in the above query that all password columns that do
not belong to selected row (username=luca) must be hidden? Anyone has an idea
about how to implement this on the database side?
Thanks,
Luca
From | Date | Subject | |
---|---|---|---|
Next Message | A. Kretschmer | 2006-11-13 13:22:05 | Re: hiding column values for specific rows |
Previous Message | Shane Ambler | 2006-11-13 12:46:14 | Re: Inserting data in composite types! |