Changeset 9243 for trunk/Open-ILS/src/sql/Pg/005.schema.actors.sql

Timestamp:

04/07/08 10:25:02 (6 months ago)

Author:

miker

Message:

adding "first5" function to trim zip codes

Files:

• trunk/Open-ILS/src/sql/Pg/005.schema.actors.sql (modified) (1 diff)

trunk/Open-ILS/src/sql/Pg/005.schema.actors.sql

@@ -511 +511 @@
 CREATE INDEX actor_org_address_org_unit_idx ON actor.org_address (org_unit);
 
+CREATE OR REPLACE FUNCTION public.first5 ( TEXT ) RETURNS TEXT AS $$
+        SELECT SUBSTRING( $1, 1, 5);
+$$ LANGUAGE SQL;
+
 COMMIT;