diff options
| author | David M <davidmj@users.sourceforge.net> | 2006-07-09 05:13:36 +0000 |
|---|---|---|
| committer | David M <davidmj@users.sourceforge.net> | 2006-07-09 05:13:36 +0000 |
| commit | 455add06f29400af3176eea7c4958ed772934460 (patch) | |
| tree | a26a855451d61860c36bc160a41894c0270f17f2 /phpBB | |
| parent | 0424200ac653a7b9f47ba0d038b944730e445bdb (diff) | |
| download | forums-455add06f29400af3176eea7c4958ed772934460.tar forums-455add06f29400af3176eea7c4958ed772934460.tar.gz forums-455add06f29400af3176eea7c4958ed772934460.tar.bz2 forums-455add06f29400af3176eea7c4958ed772934460.tar.xz forums-455add06f29400af3176eea7c4958ed772934460.zip | |
Realized that we never needed to CAST() in the first place after i remembered why i chose a DOMAIN implementation over a TYPE implementation...
DOMAINs are simpler and thus the system is capable of determining what is _really_ going on (which is why it handles indexing for us :D)
git-svn-id: file:///svn/phpbb/trunk@6160 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB')
| -rw-r--r-- | phpBB/install/schemas/postgres_schema.sql | 4 |
1 files changed, 0 insertions, 4 deletions
diff --git a/phpBB/install/schemas/postgres_schema.sql b/phpBB/install/schemas/postgres_schema.sql index 07296bf658..60b672e973 100644 --- a/phpBB/install/schemas/postgres_schema.sql +++ b/phpBB/install/schemas/postgres_schema.sql @@ -8,10 +8,6 @@ BEGIN; /* Domain definition */ CREATE DOMAIN varchar_ci AS varchar(255) NOT NULL DEFAULT ''::character varying; -CREATE CAST (varchar_ci AS varchar) WITHOUT FUNCTION AS IMPLICIT; -CREATE CAST (varchar AS varchar_ci) WITHOUT FUNCTION AS IMPLICIT; -CREATE CAST (varchar_ci AS text) WITHOUT FUNCTION AS IMPLICIT; -CREATE CAST (text AS varchar_ci) WITHOUT FUNCTION AS IMPLICIT; /* Operation Functions */ CREATE FUNCTION _varchar_ci_equal(varchar_ci, varchar_ci) RETURNS boolean AS 'SELECT LOWER($1) = LOWER($2)' LANGUAGE SQL STRICT; |