Index: openacs-4/packages/acs-subsite/www/user/basic-info-update-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/user/Attic/basic-info-update-postgresql.xql,v diff -u -N --- openacs-4/packages/acs-subsite/www/user/basic-info-update-postgresql.xql 28 Aug 2003 09:41:42 -0000 1.2 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,19 +0,0 @@ - - - - postgresql7.1 - - - - - select cr.publish_date, coalesce(cr.title,'your portrait') as portrait_title - from cr_revisions cr, cr_items ci, acs_rels a - where cr.revision_id = ci.live_revision - and ci.item_id = a.object_id_two - and a.object_id_one = :user_id - and a.rel_type = 'user_portrait_rel' - - - - -