Support for PostgreSQL SIMILAR TO command?

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
TonyV
Posts: 74
Joined: Wed 25 May 2011 15:03

Support for PostgreSQL SIMILAR TO command?

Post by TonyV » Thu 07 Jun 2012 17:54

My program has a search page on it in which I want the users to be able to specify search strings that can contain %, _, [, and ] characters. In PostgreSQL, the LIKE command does not support [ & ], but the SIMILAR TO command does.

Is there any way I can get a search that uses the SIMILAR TO command in my entity framework query?

Tony

Shalex
Site Admin
Posts: 8241
Joined: Thu 14 Aug 2008 12:44

Re: Support for PostgreSQL SIMILAR TO command?

Post by Shalex » Fri 08 Jun 2012 17:01

dotConnect for PostgreSQL includes the full support of LIKE and ILIKE via the Devart.Data.PostgreSql.Entity.PgSqlFunctions class (the Devart.Data.PostgreSql.Entity.dll assembly).

Shalex
Site Admin
Posts: 8241
Joined: Thu 14 Aug 2008 12:44

Re: Support for PostgreSQL SIMILAR TO command?

Post by Shalex » Fri 08 Jun 2012 17:02

We are investigating the possibility to support SIMILAR TO. We will post here about the results.

Shalex
Site Admin
Posts: 8241
Joined: Thu 14 Aug 2008 12:44

Re: Support for PostgreSQL SIMILAR TO command?

Post by Shalex » Mon 02 Jul 2012 08:14

The SimilarTo overloaded methods are added to the PgSqlFunctions class to provide support of the SQL SIMILAR TO statement.
We will post here when the corresponding build of dotConnect for PostgreSQL is available for download.

TonyV
Posts: 74
Joined: Wed 25 May 2011 15:03

Re: Support for PostgreSQL SIMILAR TO command?

Post by TonyV » Fri 06 Jul 2012 15:11

Thank you very much! Do you have an estimate for when this will go out?

Shalex
Site Admin
Posts: 8241
Joined: Thu 14 Aug 2008 12:44

Re: Support for PostgreSQL SIMILAR TO command?

Post by Shalex » Mon 09 Jul 2012 09:25

We are planning to release the corresponding build in the end of the next week.

Shalex
Site Admin
Posts: 8241
Joined: Thu 14 Aug 2008 12:44

Re: Support for PostgreSQL SIMILAR TO command?

Post by Shalex » Thu 19 Jul 2012 10:32

New version of dotConnect for PostgreSQL 6.1 is released!
It can be downloaded from http://www.devart.com/dotconnect/postgr ... nload.html (trial version) or from Registered Users' Area (for users with active subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?f=3&t=24525 .

TonyV
Posts: 74
Joined: Wed 25 May 2011 15:03

Re: Support for PostgreSQL SIMILAR TO command?

Post by TonyV » Mon 23 Jul 2012 12:37

When I log into the Registered Users area, I do not see a link to download version 6.x. I see a link for version 5.80.350 and for DbMonitor 3.00.3.

Why don't I see a link for the latest version?

Shalex
Site Admin
Posts: 8241
Joined: Thu 14 Aug 2008 12:44

Re: Support for PostgreSQL SIMILAR TO command?

Post by Shalex » Tue 24 Jul 2012 07:36

Please contact our Sales department (sales at devart.com).

Devart
Site Admin
Posts: 3276
Joined: Tue 26 Oct 2004 13:51

Re: Support for PostgreSQL SIMILAR TO command?

Post by Devart » Wed 25 Jul 2012 07:11

Hello,

Please email to our sales your license number or registration email as we couldn't see dotConnect for PostgreSQL license registered for your email.

Regards,
Devart Support

TonyV
Posts: 74
Joined: Wed 25 May 2011 15:03

Re: Support for PostgreSQL SIMILAR TO command?

Post by TonyV » Wed 25 Jul 2012 14:14

It's not registered to my name, it's registered to my boss. I'll get the information and and email it.

Post Reply