Hi,
I try to set up a view that selects rows from a table according the
connected user. However, I issue
CREATE VIEW v_dummy AS
SELECT
dummy
, usr
FROM t_dummy
WHERE usr = CURRENT_USER
;
but the following error is returned.
ERROR: Unable to identify an operator '=' for types 'character varying'
and 'name'. You will have to retype this query using an explicit cast.
So I to_char(CURRENT_USER, *somewhat*) but to no avail.
I'd appreciate any hint. BTW, I use DBVisualizer 2.1 to build my dbs.
Thx
Thiemo
--
Thiemo Kellner
Tösstalstrasse 146
CH-8400 Winterthur