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
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.
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2002-03-30 04:13:17|
|Subject: Re: CURRENT_USER |
|Previous:||From: Lewis Bergman||Date: 2002-03-29 18:17:57|
|Subject: INSERT for inherited tables|