[HACKERS] Generalized edit function?

2011-02-26 Thread fork
Hi hackers, I am interested in extending Postgres with a generalized edit function like SAS's compged[1], which is basically levenshtein distance with transposes (ab - ba) and LOTS of different weights for certain ops (like insert a blank versus delete from the end versus insert a regular

Re: [HACKERS] Generalized edit function?

2011-02-26 Thread fork
Robert Haas robertmhaas at gmail.com writes: On Sat, Feb 26, 2011 at 4:19 PM, Josh Berkus josh at agliodbs.com wrote: Anyway, if it's ASCII-only, that's a guaranteed way to make sure it isn't taken seriously. Pre-9.1 levenshtein is ASCII-only, and I think some of the other stuff in

Re: [HACKERS] PHP 4.0.4pl1 / Beta 5

2001-02-18 Thread Michael Fork
fault_link) != id) { PGG(default_link) = id; zend_list_addref(id); } } - Michael Fork - CCNA - MCP - A+ Network Support - Toledo Internet Access - Toledo Ohio On Sun, 18 Feb 2001, Bruce Momjian wrote: [ Charset ISO-8859-1 unsupported, converting... ] I sure hope it

Re: AW: [HACKERS] Three types of functions, ala function redux.

2000-12-21 Thread Michael Fork
0.00..2.01 rows=1 width=4) EXPLAIN testdb=# explain select * from test where col = func_test(1); NOTICE: QUERY PLAN: Seq Scan on test (cost=0.00..100.00 rows=1 width=4) EXPLAIN Michael Fork - CCNA - MCP - A+ Network Support - Toledo Internet Access - Toledo Ohio On Thu, 21 Dec 2000, mlw wrote: Z

RE: [HACKERS] SQL to retrieve FK's, Update/Delete action, etc. (fwd)

2000-12-05 Thread Michael Fork
Here's the query that, given the primary key table, lists all foreign keys, their tables, the RI type, and defereability. Michael Fork - CCNA - MCP - A+ Network Support - Toledo Internet Access - Toledo Ohio SELECT pg_trigger.tgargs, pg_trigger.tgnargs, pg_trigger.tgdeferrable

Re: [HACKERS] beta testing version

2000-12-04 Thread Michael Fork
sense in the future (who knows, maybe next they will implement RS returning SP's or clusters, projects that are funded with their profit off the advanced replication and distributed information capabilities that they *may* withhold -- would people still be whining then?) Michael Fork - CCNA - MCP -

RE: [HACKERS] SQL to retrieve FK's, Update/Delete action, etc. (fwd)

2000-12-04 Thread Michael Fork
the foreign keys and primary keys and tables, you must parse the null-terminated pg.tgargs. When I get the equivalent query working for primary keys I will send it your way -- or if you beat me to it, send it my way (I am working on some missing functionality from the ODBC driver) Michael Fork

[HACKERS] RI Types

2000-12-02 Thread Michael Fork
nd the one that is used depends on what the user puts in the REFERENCES line. Am I correct? Michael Fork - CCNA - MCP - A+ Network Support - Toledo Internet Access - Toledo Ohio On Fri, 1 Dec 2000, Stephan Szabo wrote: It's representing a single null I believe. I'm not sure if in general it'

[HACKERS] ODBC Driver

2000-12-01 Thread Michael Fork
I am curious as to where the newest ODBC driver source is -- I retrieved /src/interfaces/odbc from CVS, but it appeared to only be version 6.40.0009 and was lacking the Visual C++ workspace/project files that were in the 6.50. release zip file on the FTP server. Thanks Michael Fork - CCNA

Re: [HACKERS]

2000-11-30 Thread Michael Fork
try this SELECT age(max(h_date), now()) FROM table WHERE email='hawks@vsnl'; Michael Fork - CCNA - MCP - A+ Network Support - Toledo Internet Access - Toledo Ohio On Thu, 30 Nov 2000, Manish Vig wrote: Dear Sir, thanks for the reply. I tried select now() but it gives

[HACKERS] pg_trigger and tgargs

2000-11-30 Thread Michael Fork
in foreign key primary_int_1\000 -- 1st field in referenced primary key foreign_int_2\000 -- 1st field in foreign key primary_int_2\000 -- 1st field in referenced primary key Thanks Michael Fork - CCNA - MCP - A+ Network Support - Toledo Internet Access - Toledo Ohio

[HACKERS] Query returning incorrect results

2000-10-08 Thread Michael Fork
some limitations, and two of the relations used are views, so I belive that that may be the problem, but I want to be sure... Thanks Michael Fork - CCNA - MCP - A+ Network Support - Toledo Internet Access - Toledo Ohio football=# SELECT play.play_id as play_id, year.correct_picks