CVS log for mysqlcompat/mysqlcompat/string.sql

Up to [pgFoundry] / mysqlcompat / mysqlcompat

Request diff between arbitrary revisions

Default branch: MAIN

Revision 1.15 / (download) - annotate - [select for diffs], Tue Dec 6 18:52:10 2011 UTC (5 months, 1 week ago) by jablonov
Branch: MAIN
CVS Tags: HEAD
Changes since 1.14: +7 -60 lines
Diff to previous 1.14 (unified)

Update string and datetime functions to be valid on PostgreSQL 8.4 and higher. Drop cast, aggregate and operator if exists before it is created. Retested on 8.4.x, 9.0.x, 9.1.x

Revision 1.14 / (download) - annotate - [select for diffs], Sat Nov 10 06:07:49 2007 UTC (4 years, 6 months ago) by xzilla
Branch: MAIN
Changes since 1.13: +59 -1 lines
Diff to previous 1.13 (unified)

we also need a version for int vars for oct() to work

Revision 1.13 / (download) - annotate - [select for diffs], Sat Nov 10 05:53:23 2007 UTC (4 years, 6 months ago) by xzilla
Branch: MAIN
Changes since 1.12: +1 -1 lines
Diff to previous 1.12 (unified)

Another 8.3 data type issue... using '0' allows comparison
against int or text, since the type isnt determined until
compare time.

Revision 1.12 / (download) - annotate - [select for diffs], Sat Nov 10 04:44:57 2007 UTC (4 years, 6 months ago) by xzilla
Branch: MAIN
Changes since 1.11: +1 -1 lines
Diff to previous 1.11 (unified)

the 1 and 0 need to be quoted in 8.3, lest they be interpreted as integers by replace

Revision 1.11 / (download) - annotate - [select for diffs], Tue Dec 13 01:41:19 2005 UTC (6 years, 5 months ago) by swm
Branch: MAIN
CVS Tags: REL_1-0-B3
Changes since 1.10: +4 -3 lines
Diff to previous 1.10 (unified)

Update comment

Revision 1.10 / (download) - annotate - [select for diffs], Mon Dec 12 13:11:31 2005 UTC (6 years, 5 months ago) by swm
Branch: MAIN
Changes since 1.9: +344 -0 lines
Diff to previous 1.9 (unified)

Implement make_set().
Note: we don't support NULL arguments to make_set().
This is because we use arrays underneath make_set() to ease implementation.
We wont have NULL array element support until 8.2

Revision 1.9 / (download) - annotate - [select for diffs], Mon Dec 12 02:00:42 2005 UTC (6 years, 5 months ago) by swm
Branch: MAIN
Changes since 1.8: +4 -1 lines
Diff to previous 1.8 (unified)

comments tidy up

Revision 1.8 / (download) - annotate - [select for diffs], Fri Dec 2 02:18:20 2005 UTC (6 years, 5 months ago) by chriskl
Branch: MAIN
CVS Tags: REL_1-0-B2, REL_1-0-B1
Changes since 1.7: +0 -6 lines
Diff to previous 1.7 (unified)

Add benchmark(), coercibility(), bit_count() and remove bit_length()

Revision 1.7 / (download) - annotate - [select for diffs], Thu Dec 1 11:50:33 2005 UTC (6 years, 5 months ago) by chriskl
Branch: MAIN
Changes since 1.6: +16 -0 lines
Diff to previous 1.6 (unified)

Add substring_index()

Revision 1.6 / (download) - annotate - [select for diffs], Thu Dec 1 11:28:40 2005 UTC (6 years, 5 months ago) by chriskl
Branch: MAIN
Changes since 1.5: +102 -3 lines
Diff to previous 1.5 (unified)

New functions: CONV() from Gavin Sherry, OCT() (depended on CONV() and UNHEX() (depended on CONV())

Revision 1.5 / (download) - annotate - [select for diffs], Wed Nov 30 15:02:24 2005 UTC (6 years, 5 months ago) by chriskl
Branch: MAIN
Changes since 1.4: +213 -2 lines
Diff to previous 1.4 (unified)

Almost every MySQL string function implemented (even soundex()).  README updated for case-sensitive strings mention.

Revision 1.4 / (download) - annotate - [select for diffs], Wed Nov 30 06:32:06 2005 UTC (6 years, 5 months ago) by chriskl
Branch: MAIN
Changes since 1.3: +59 -2 lines
Diff to previous 1.3 (unified)

More additions to the readme.  Move all operators toone file.  Many more string functions.

Revision 1.3 / (download) - annotate - [select for diffs], Wed Nov 30 02:57:52 2005 UTC (6 years, 5 months ago) by chriskl
Branch: MAIN
Changes since 1.2: +72 -2 lines
Diff to previous 1.2 (unified)

Start on the MySQL string functions

Revision 1.2 / (download) - annotate - [select for diffs], Tue Nov 29 08:09:25 2005 UTC (6 years, 5 months ago) by chriskl
Branch: MAIN
Changes since 1.1: +12 -0 lines
Diff to previous 1.1 (unified)

Add MySQL && and || operators.  Protect other stored procs to always use the pg_catalog || for concatentation

Revision 1.1 / (download) - annotate - [select for diffs], Fri Nov 25 05:54:05 2005 UTC (6 years, 5 months ago) by chriskl
Branch: MAIN

Add <=> null safe comparison.  Move all files to root dir.

This form allows you to request diff's between any two revisions of a file. You may select a symbolic revision name using the selection box or you may type in a numeric name using the type-in text box.