AW: [SQL] Problems with RULE

eleted=false > DELETE FROM t_xyz WHERE NOT(old.deleted=false) > [...] Oh ... that's it! I hit my head against the wall :-) Thank you very much! Best regards, Jens Hartwig - T-Systems Projektleiter debis Systemhaus GEI GmbH Hausan

AW: [SQL] Problems with RULE

tp://www.t-systems.de > -Ursprüngliche Nachricht- > Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Gesendet: Dienstag, 6. März 2001 19:10 > An: Jens Hartwig > Cc: PSQL-Sql (E-Mail) > Betreff: Re: [SQL] Problems with RULE > > > On 3/6/01, 7:11:48 AM, Jens Hartwig

AW: [SQL] Problems with RULE

JH: > > [...] > > I tried to implement the following rule: if someone wants to delete a record > > from a table t_xyz (id integer, deleted boolean) the record should get a > > delete-flag (deleted = true). When this "pre-deleted" record is deleted for > > the next time it should be physically dele

[SQL] Problems with RULE

is really a bug? Best regards, Jens Hartwig PS: You will find the scripts in the attachment. - T-Systems Projektleiter debis Systemhaus GEI GmbH Hausanschrift: Eichhornstraße 3, 10785 Berlin Postanschrift: 10785 Berlin Telefon: (004930) 25 54

[SQL] Tuple is too big ...

Hello all, I am running PostgreSQL-7.0.3. I changed the value of BLCKSZ (in "include/config.h" to 16384, recompiled and reinstalled the sources. After having restarted the backend I tried to create a table with three varchar(5000)-columns and tried to add three character-values with each 4000 cha

Re: [SQL] create default

should define cno1 as long as the maximum length of cno2 and cno3 together (20). Regards, Jens Jens Hartwig schrieb: > > > hi,how to set default filed+field > > > > create table "table1"( > > "cno1" char(10) default NEW.cno2+NEW.cno3, > >

Re: [SQL] create default

ELSE new.cno1 := substr(new.cno2,1,3)||substr(new.cno3,1,3); END IF; END IF; RETURN new; END;' LANGUAGE 'plpgsql'; CREATE TRIGGER test_trg BEFORE INSERT OR UPDATE ON table1 FOR EACH ROW EXECUTE PROCEDURE test(); INSERT INTO

Re: Sv: [SQL] how to build this query ??? Please help !!!

;) and AFAIK in no other relational database. I really cannot imagine any equivalent join-statement (or anything else like a subquery) which brings the same results! Does this at all correlate with the philosophy of a relational database? Best regards, Jens ==

Re: Sv: [SQL] how to build this query ??? Please help !!!

lects (what a poor database engineer I would be otherwise ;-)) but I have never seen a statement like SELECT a, (SELECT b) FROM xyz; IMHO this is no normal subselect and it does not correlate with the SQL-standard. Is it a trick? Best regards, Jens =======

Re: Sv: [SQL] how to build this query ??? Please help !!!

but I never before have seen such a construct in SQL! Best regards, Jens Hartwig ===== Jens Hartwig - debis Systemhaus GEI mbH 10875 Berlin Tel. : +49 (0)30 2554-3282 Fax : +49 (0)30 2554-3187 Mobil: +

Re: [SQL] order by day or month, etc

g this: > SELECT to_char(field, 'DD/MM/') AS new_date > > as Francis Solomon said, didnt work... "unrecognized function" ... > [...] ========= Jens Hartwig - debis Systemhaus GEI mbH

[SQL] Strange Execution-Plan for NOT EXISTS

st regards, Jens ========= Jens Hartwig - debis Systemhaus GEI mbH 10875 Berlin Tel. : +49 (0)30 2554-3282 Fax : +49 (0)30 2554-3187 Mobil: +49 (0)170 167-2648 E-Mail : [EMAIL PROTECTED] =

[SQL] How to identify connected Users?

Hello all, is there any way to identify users which are currently connected to the database? Does perhaps even exist a method to notify this users (e.g. to close the connection)? Thanks in advance and best regards, Jens = Jens Hartwig

Re: [SQL] Damaged table "pg_access"

problem? Can I rudely remove the granted permissions by any command (e.g. deleting it manually from the system catalogue)? Best regards, Jens Tom Lane schrieb: > > Jens Hartwig <[EMAIL PROTECTED]> writes: > > when I try to access the system-table "pg_class", I

[SQL] Damaged table "pg_access"

before or while processing the request. The connection to the server was lost. Attempting reset: Failed. !# What happened? Is there any way to repare the damaged table? Thanks in advance for all of you, who spend their valuable time! Best regards, Jens

Re: [SQL] removing a DB??

oett http://erm1.u-strasbg.fr/~bboett > ======= > the total amount of intelligence on earth is constant. > human population is growing -- Herzliche Grüße, Jens Hartwig = Jens Hartwig

Re: [SQL] search and replace possible on SQL?

Hello Bruno, try the following: UPDATE journal SET description = 'Add '||description WHERE description LIKE '%PSF%; Is this what you wanted? Best regards, Jens Hartwig Bruno Boettcher schrieb: > > hello, > > again fiddling around with SQL... > wanted to