Support SUBSTRING(X FROM Y[ FOR Z]) on PostgreSQL

[Former user]

The Firebird dialect compiles {{func.substring(x, yz)}} to {{SUBSTRING(X FROM Y[ FOR Z])}}. I'd like to do the same for PostgreSQL. Will post a patch.

[Former user]

Simple patch against rel_0_7 tip, copying code from firebird dialect

[Former user]

Same patch applies with minimal fuzz to default (do you still want separate patch files in such cases?)

[Mike Bayer]

i think its fine, how far back does SUBSTRING go for PG versions ?

[Former user]

Back to at least 7.1 for integers http://www.postgresql.org/docs/7.1/static/functions-string.html ... regexp variant was added in 7.3 http://www.postgresql.org/docs/7.3/static/functions-string.html

[Mike Bayer]

seems like PG9 doesn't need the extra words:

test=> select substring('foobar' from '%#"o_b#"%' for '#')
test-> ;
 substring 
-----------
 oob
(1 row)

test=> select substring('foobar', '%#"o_b#"%', '#')
;
 substring 
-----------
 oob
(1 row)

trying to see what version i should document this as necessary for.

[Mike Bayer]

a0de45185bf510fca9e237d9191e89391d118591 c74547164d290193fd4798601c2b7b770969a9d0 thanks !

[Mike Bayer]

Removing milestone: 0.8.0final (automated comment)