Re: [SQL] sql question:

2002-07-15 Thread Ahti Legonkov
. All in all > there are probably 20 possible values and the permutations are to lengthy to > put in a 'like', so I need some kind of algorithm. Does anyone have any > ideas? The algorithm is as simple as that: if (value & 64 == 64) { // it is a delete } --

[SQL] rules / triggers on insert. why after?

2002-07-12 Thread Ahti Legonkov
E PROCEDURE insert_lreo(); end On postgres 7.1.3 it was OK to do this: INSERT INTO "lreo" ("STREET", "PRICE", "CITY") VALUES ('street', 1234, 'the city'); but on postgres 7.2 and 7.2.1 I get an error that "REO_ID_seq.currval

[SQL] Why doesn't it use indexes?

2002-07-02 Thread Ahti Legonkov
width=133) Why it does not use indexes I have created? -- Ahti Legonkov ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly