Hi Roy,
They were introduced with the support for CLOBS in 9.2.0 as it provided
a more LOB efficient means of saying: lob LIKE pata OR lob LIKE patb
etc. which would have meant two (or more) scans of the lob.
Regards,
Ian

-----Original Message-----
From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of Roy
Hann
Sent: 22 January 2010 08:04
To: info-ingres (AT) kettleriverconsulting (DOT) com
Subject: [Info-Ingres] Alternates in LIKE

Can anyone tell me which Ingres release first introduced alternates in
the LIKE predicate?

--
Roy

UK Ingres User Association Conference 2010 will be on Tuesday June 8
2010
Go to http://www.iua.org.uk/join to get on the mailing list.


_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://ext-cando.kettleriverconsulti...fo/info-ingres

Thank you Ian.


--
rhann