thiemo <thiemo(at)gmx(dot)ch> writes:
> WHERE usr =3D CURRENT_USER
> but the following error is returned.
> ERROR: Unable to identify an operator '=3D' for types 'character varying'=
> and 'name'. You will have to retype this query using an explicit cast.
Hmm... probably there should be an implicit conversion from NAME to TEXT
.. but in the meantime try
WHERE usr = CURRENT_USER::varchar
regards, tom lane
In response to
pgsql-novice by date
|Next:||From: thiemo||Date: 2002-03-30 09:19:08|
|Subject: Strange insert|
|Previous:||From: thiemo||Date: 2002-03-30 02:02:26|