Laurent,
take a look at contrib/tsearch2
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/
It does exactly what you want and more.
Oleg
On Fri, 29 Aug 2003, Laurent Patureau wrote:
>
> Hi,
>
> I'm looking for a SELECT request on PostgreSQL for a search engine.
> I'd like the reques
Hi,
I'm looking for a SELECT request on PostgreSQL for a search engine.
I'd like the request return me the pertinence (relevance) of each
result.
I've found the MySQL syntax on the web :
mysql> SELECT id, body, MATCH (title,body) AGAINST
-> ('Security implications of running MySQL as root') AS
On Friday 29 August 2003 06:50, Anuradha Ratnaweera wrote:
[snipped description of groups consisting of unique lists of members, i.e.
group A contains (1,2,3) so B can't contain the same]
I was looking at something almost identical a few days ago.
> Then we added a unique string field to t3 whic
Hi all,
o We have a table t1 which has a primary key id and other fields.
(say, 10 rows with ids 1 to 10).
o We need to group rows (unordered, and arbritrary size) in t1 and
assign a unique id to each group. (e.g.: {1, 3, 4} is group 1, {1, 5}
is group 2 etc.)
o A group shouldn't change
Hi
Kumar,
You'll
need to use PL/pgSQL for your stored procedures.
When I
migrated from Informix I found it was pretty easy - just a syntactic conversion
of the procedures and a few data types to rename. The tricky bit is when you
have used a MS SQL Server concept that PostgreSQL doesn't
Dear Friends,
I am about to do a migration of
stored procedures from MS SQL Server to Postgres. What is there any free tools
available for it?
Shall I write a SQL function or
PL/pgSQL function for Stored Procedures? Please advise me on this. Thanks in
advance.
Kumar
