Support for PostgreSQL SIMILAR TO command?

Support for PostgreSQL SIMILAR TO command?

Postby 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
TonyV
 
Posts: 74
Joined: Wed 25 May 2011 15:03

Re: Support for PostgreSQL SIMILAR TO command?

Postby 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
Devart Team
 
Posts: 7654
Joined: Thu 14 Aug 2008 12:44

Re: Support for PostgreSQL SIMILAR TO command?

Postby Shalex » Fri 08 Jun 2012 17:02

We are investigating the possibility to support SIMILAR TO. We will post here about the results.
Shalex
Devart Team
 
Posts: 7654
Joined: Thu 14 Aug 2008 12:44

Re: Support for PostgreSQL SIMILAR TO command?

Postby 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.
Shalex
Devart Team
 
Posts: 7654
Joined: Thu 14 Aug 2008 12:44

Re: Support for PostgreSQL SIMILAR TO command?

Postby TonyV » Fri 06 Jul 2012 15:11

Thank you very much! Do you have an estimate for when this will go out?
TonyV
 
Posts: 74
Joined: Wed 25 May 2011 15:03

Re: Support for PostgreSQL SIMILAR TO command?

Postby Shalex » Mon 09 Jul 2012 09:25

We are planning to release the corresponding build in the end of the next week.
Shalex
Devart Team
 
Posts: 7654
Joined: Thu 14 Aug 2008 12:44

Re: Support for PostgreSQL SIMILAR TO command?

Postby 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/postgresql/download.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 .
Shalex
Devart Team
 
Posts: 7654
Joined: Thu 14 Aug 2008 12:44

Re: Support for PostgreSQL SIMILAR TO command?

Postby 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?
TonyV
 
Posts: 74
Joined: Wed 25 May 2011 15:03

Re: Support for PostgreSQL SIMILAR TO command?

Postby Shalex » Tue 24 Jul 2012 07:36

Please contact our Sales department (sales at devart.com).
Shalex
Devart Team
 
Posts: 7654
Joined: Thu 14 Aug 2008 12:44

Re: Support for PostgreSQL SIMILAR TO command?

Postby 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
Devart
Devart Team
 
Posts: 3107
Joined: Tue 26 Oct 2004 13:51

Re: Support for PostgreSQL SIMILAR TO command?

Postby 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.
TonyV
 
Posts: 74
Joined: Wed 25 May 2011 15:03


Return to dotConnect for PostgreSQL