Index: openacs-4/packages/acs-kernel/sql/postgresql/acs-objects-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/acs-objects-create.sql,v diff -u -N -r1.21 -r1.22 --- openacs-4/packages/acs-kernel/sql/postgresql/acs-objects-create.sql 3 Jul 2001 00:09:40 -0000 1.21 +++ openacs-4/packages/acs-kernel/sql/postgresql/acs-objects-create.sql 6 Jul 2001 00:19:14 -0000 1.22 @@ -994,7 +994,7 @@ -- function get_attribute create function acs_object__get_attribute (integer,varchar) -returns varchar as ' +returns text as ' declare object_id_in alias for $1; attribute_name_in alias for $2; @@ -1012,7 +1012,7 @@ v_table_name := acs_object__get_attr_storage_table(v_storage); v_key_sql := acs_object__get_attr_storage_sql(v_storage); - for v_rec in execute ''select '' || quote_ident(v_column) || ''::varchar as return from '' || quote_ident(v_table_name) || '' where '' || v_key_sql + for v_rec in execute ''select '' || quote_ident(v_column) || ''::text as return from '' || quote_ident(v_table_name) || '' where '' || v_key_sql LOOP v_return := v_rec.return; exit;