Index: openacs-4/packages/notes/sql/postgresql/notes-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/notes/sql/postgresql/notes-create.sql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/notes/sql/postgresql/notes-create.sql	3 Sep 2001 17:55:51 -0000	1.3
+++ openacs-4/packages/notes/sql/postgresql/notes-create.sql	10 Oct 2001 05:16:23 -0000	1.4
@@ -21,7 +21,7 @@
 	null,				-- package_name
 	''f'',				-- abstract_p
 	null,				-- type_extension_table
-	null				-- name_method
+	''note.name''		-- name_method
 	);
 
     return 0;
@@ -144,14 +144,20 @@
 
 end;' language 'plpgsql';
 
+create function note__name (integer)
+returns varchar as '
+declare
+    p_note_id      alias for $1;
+    v_note_name    notes.title%TYPE;
+begin
+	select title into v_note_name
+		from notes
+		where note_id = p_note_id;
 
--- neophytosd
-\i notes-sc-create.sql
+    return v_note_name;
+end;
+' language 'plpgsql';
 
 
-
-
-
-
-
-
+-- neophytosd
+\i notes-sc-create.sql