Regular Expression - SubString At a set point .postgreSQL

[saddle88]

For a custom stat Im making, the string is always a set length and only digits. Im looking for a regEx that always returns for example the 3rd and 4th digit from the string. ie- 9941991842 - Returns " 41 " .

learning regular expressions just recently, thanks.

[saddle88]

\d\d(?=\d{68}$)

boom.

[saddle88]

SQL is always one step ahead...
SUBSTRING( string FROM x FOR y )

[saddle88]

\d\d(?=\d{68}$)

boom.

and this is in jsoft and not posix, im on a roll

[kraada]

I'd do things using SUBSTRING for the most part - but it sounds like you were able to work out what you needed?

[saddle88]

I just want to know whats possible, with so little seemingly in str_ format there isnt much I dont think.

?

for example what I posted before, even if it was the correct regex flavor there's no spot to apply something for a numeric string. Is there anything beyond -edit- enum* instances and the static referencing info for charts and such that can be accessed by substring??

[kraada]

SQL is allowed in the custom column creation section so long as the resulting value is numeric. All HUD stats are calculated by looping over all hands played by a given player.

For more detail on what sort of string functions SQL has, you can see this documentation page.