Hi all,
I have a list of purchases (market basket) and I would like to select
non redundant longest possible patterns by eliminating
(creating/populating other table to contain only non redandant itemsets)
purchases having item lists which are fully included in at least one
other purchase.
(Am
Allan Kamau wrote:
Hi all,
I have a list of purchases (market basket) and I would like to select
non redundant longest possible patterns by eliminating
(creating/populating other table to contain only non redandant itemsets)
purchases having item lists which are fully included in at least one
Craig Ringer wrote:
Allan Kamau wrote:
Hi all,
I have a list of purchases (market basket) and I would like to select
non redundant longest possible patterns by eliminating
(creating/populating other table to contain only non redandant itemsets)
purchases having item lists which are fully
-- Find any `a' for which `item_from_a_is_in_b' is
-- true for all items in `a'
SELECT a_tid AS is_redundant, b_tid AS contained_by
FROM (
-- For every item in every pair of purchases,
-- determine whether the item in purchase `a'
-- was also in purchase `b'.
SELECT
a.tid AS
Craig,
Thank you so much for the solution. I have spent many hours since
Thursday last week including the weekend (and it took you just a few
minutes) trying to figure out a solution not involving procedural
programming and looping (as the size of the items and even the number of
purchases in
Good morning,
Is there a command to drop tables whose name begins a specific string?
For example, all backup tables begins with backup_2007:
Drop table where tableName like 'backup_2007%'?
Thanks a lot!
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your
Emi Lu [EMAIL PROTECTED] writes:
Is there a command to drop tables whose name begins a specific string?
No. The standard answer to this type of problem is to write a little
plpgsql function that scans the appropriate catalog and issues commands
constructed with EXECUTE.
for r in select
Tom Lane wrote:
Note that the above is overly simplistic --- it doesn't pay attention
to schemas, for example.
These are what I use.
BEGIN;
CREATE SCHEMA util;
CREATE OR REPLACE FUNCTION util.exec_all(objtype name, schname name,
objname name, cmd TEXT) RETURNS text AS $$
DECLARE
Hi dudes. Im trying to find out how to deal with this. I just receive a
1.2 MB wal file (may some 'windows home version' do that?), and obviosly,
when i try to recovery from there, get the 'incorrect file size' error.
Acording to the docs, wal file size can be changed at compile time. Not so
bad,
[EMAIL PROTECTED] writes:
Hi dudes. Im trying to find out how to deal with this. I just receive a
1.2 MB wal file (may some 'windows home version' do that?), and obviosly,
when i try to recovery from there, get the 'incorrect file size' error.
Acording to the docs, wal file size can be changed
10 matches
Mail list logo