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 ch
Robert Haas gmail.com> writes:
>
> On Sat, Feb 26, 2011 at 4:19 PM, Josh Berkus 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 contrib/fuzzys
Thought this may be of interest to some...
http://www.phpbuilder.com/columns/tim20001112.php3
Michael Fork - CCNA - MCP - A+
Network Support - Toledo Internet Access - Toledo Ohio
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 se
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
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
ne 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 i
AND pg_proc.oid = pg_trigger.tgfoid
AND pg_trigger_1.tgfoid = pg_proc_1.oid
AND pg_trigger_1.tgconstrrelid = pc.oid
AND ((pc.relname='tblmidterm')
AND (pp.proname LIKE '%ins')
AND (pg_proc.proname LIKE '%upd')
AND (pg_proc_1.proname LIKE '%del'))
Michae
his to make 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 For
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
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.tgdefer
OTICE: QUERY PLAN:
Index Scan using idxtest on test (cost=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
This is the closest thing to what you want:
GRANT ALL ON table TO user;
(see http://www.postgresql.org/users-lounge/docs/7.0/user/sql-grant.htm)
Michael Fork - CCNA - MCP - A+
Network Support - Toledo Internet Access - Toledo Ohio
On Wed, 31 Jan 2001, Martin A. Marques wrote:
> El Mar 30
}
if (PGG(default_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, converti
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
as
-
play_id | int4| not null default nextval('...
play_online | bool| default 'f'
play_name | varchar(30) | not null
play_username | varchar(16) | not null
play_password | varchar(16) | not null
which is incorrect accoring to the initial query. It appears to be
ordering the individual selects and then appending the second query to
the first -- is this correct?
Thanks
Michael Fork - CCNA - MCP - A+
Network Support - Toledo Internet Access - Toledo Ohio
16 matches
Mail list logo