Re: [SQL] change a field

> I want to change a field of a record after the modification of another > field of the same record or during an insert of a new record. You can easily accomplish this in a BEFORE trigger. It is applicable for both insert & update. regards, bhuvaneswaran ---(end of bro

Re: [SQL] Linked Lists example.

Jesse, >> This approach probably wouldn't work out very well if you needed to pull the content out of the database on every view because there are >> lots of queries and loops involved in following the list. Yes I see. As usual with web development the 'flow of information' dictates alot in whi

Re: [SQL] change a field

Patrick Meylemans writes: > What is the best way to solve this problem ? Show us your code. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregist

Re: [SQL] Linked Lists example.

Jesse, Thanks - that's a good example. Could you also have built you CMS solution without linked lists ? I'm curious to see if the rule 'there's more than one way to the top of the mountain' applies here as it usualy does. Cheers Rudi. Jesse Scott wrote: In my current CMS project, I use a link

[SQL] Plz, what is the most "correct" method

Hi, Given 2 tables: Table1: idAuto,int,PrimKey table2idint txt nvarchar50 Table2: idAuto,int,PrimKey order int The scenario: Table2.order defines how the table1.txt is should be ordered. Table1.table2id contains the id of the order. This cannot be changed How do I select all Ta

[SQL] change a field

Dear, I want to change a field of a record after the modification of another field of the same record or during an insert of a new record. Suppose the following table field | type -- id | serial sign| integer value | i

[SQL] MD5() function not available ??

Hey, I've searched for MD5 crypting function in PG, but I did not find it. Anyone knows how to implement this function in PG ? Best wishes, Marek L. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archive

Re: [SQL] A generic trigger?

Peter Childs <[EMAIL PROTECTED]> writes: > Yes it is possible and I've done it. The reason I'm not using it is because I > wrote it in Pl/Python and if you attach the same trigger to more than one > table in the same transaction pg/python (actually the entire server crashes > but thats not the po

[SQL]

 

[SQL] Linked Lists example.

Hi, Can anyone give me a real world example of where a 'linked list' would be used in PostgreSQL or SQL in general. Just been reading up a little on them and am wondering how/when to use them. Many thanks Rudi. ---(end of broadcast)--- TIP 9: the p

Re: [SQL] A generic trigger?

--- Peter Childs <[EMAIL PROTECTED]> wrote: > Yes it is possible and I've done it. The reason I'm not using it is because > I > wrote it in Pl/Python and if you attach the same trigger to more than one > table in the same transaction pg/python (actually the entire server crashes > but that

Re: [SQL] A generic trigger?

On Sunday 14 September 2003 02:13, ow wrote: > Hi, > > Am looking for a way to minimize the amount of fuctions that support > triggers. E.g., there's "company" and "company_backup" tables. Update > trigger on the "company" table will put a record in the "company_backup" > table whenever "company" r

Re: [SQL] Column Types

On Sun, 2003-09-14 at 07:49, Muhyiddin A.M Hayat wrote: > If in MySQL i'm using type EMUN what type in Postgres? Use a CHECK constraint: CREATE TABLE xxx ( ... colourTEXT CHECK (colour IN ('red', 'green', 'blue')), ... ); -- Oliver Elphick[EMAIL PR

[SQL] Column Types

If in MySQL i'm using type EMUN what type in Postgres?