• last updated 2 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates

Fixed some errors in my earlier hacking on hierarchical queries...

  1. … 3 more files in changeset.

Added code to make use of David Walker's wonderfully abusive hack on the

pg_proc table that showed me how to write recursive SQL functions. We now

have good use of the index on tree_sortkey when climbing the tree, woo-hoo!

  1. … 18 more files in changeset.

Changed the representation of tree_sortkeys from "text" to "bit varying".

    • -24
    • +14
    ./file-storage-procs-postgresql.xql
  1. … 62 more files in changeset.
Various changes to support storage in filesystem

  1. … 4 more files in changeset.
Wrappers to CR API

  1. … 10 more files in changeset.
Oops on colunm name, fixed ordering

Fixed context_bar to more closely mimic oracle behavior

    • -10
    • +9
    ./file-storage-procs-postgresql.xql
fs_file_p must check file_storage_item for content_type in CR

Changed connect by so that anscestors, not children, are calculated

    • -11
    • +11
    ./file-storage-procs-postgresql.xql
Removed level attribute in fs_context_bar_lis.context_bar query

Initial port

    • -0
    • +43
    ./file-storage-procs.xql
Inital port

    • -0
    • +100
    ./file-storage-procs-oracle.xql
    • -0
    • +107
    ./file-storage-procs-postgresql.xql

Forgot to define binary files before importing, so .gifs were messed up.

  1. … 2478 more files in changeset.
Initial revision

    • -0
    • +9
    ./file-storage-init.tcl
    • -0
    • +232
    ./file-storage-procs.tcl
  1. … 2478 more files in changeset.