[Info-ingres] weird string processing request

[Martin Bowes]

Holy Snapping Duck Shit....That looks great.

I will have to dig that out shortly and give it a serious playing with.

Way cool!

Marty

-----Original Message-----
From: Roy Hann [mailto:specially at processed.almost.meat] 
Sent: 09 October 2018 17:07
To: info-ingres at lists.planetingres.org
Subject: Re: [Info-ingres] weird string processing request

Martin Bowes wrote:

> Yes the tag names are known, fixed in order and number.
>
> I'm pretty sure that SIMILAR TO is a search predicate and 
> only returns a true false to a where clause and will not return a
> matching value.

You're in for a treat then.  :-)

Ingres 11 now has a substring() function which takes a regular
expression. The syntax is 

  SUBSTRING( s SIMILAR TO pattern ESCAPE esc_character [modifier] )

It's on page 126 of the PDF version of the SQL Reference Guide I
happen to have at hand.

Roy

_______________________________________________
Info-ingres mailing list
Info-ingres at lists.planetingres.org
https://lists.planetingres.org/mailman/listinfo/info-ingres