Re: [SQL] Working with XML.

Title: Working with XML. Hi Theo,   I am not aware of any means of passing xml to stored procedures, apart from writing your own function to parse the xml.   In regard to your second question - how to access the second record - try using a more explicit xpath query incorporating a "where" co

Re: [SQL] copy rows

I have not been too deep into 8.0, but AFAIK from the 7.x releases, the only way to do things like you describe, is do it the hard way: use SELECT INTO to get the field values you want into variables modify the necessary field values do the INSERT via Executing A Dynamic Command Inserting a re

[SQL] triggers

update trigger working on same table??? ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [SQL] triggers

On Mon, Feb 14, 2005 at 05:42:27PM +0200, ALÝ ÇELÝK wrote: > > update trigger working on same table??? Could you be more specific, please? What are you trying to do? -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---(end of broadcast)--- TIP 8: ex

Re: [SQL] triggers

update trigger working on same table??? If an UPDATE trigger does an update on its own table, it can trigger itself and explode... ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomai

Re: [SQL] Working with XML.

Title: Message Thanks George.       How do you get an attributes value the following returns the attribute tag. i.e. rows="100", all i want is the 100.    select pgxml_xpath('284122789648{ts ''2005-02-14 16:13:18''}unbnda8m5946z55sgi1xco34h1q9tLonoys3nyk1d5tgtLaw8h5wya0zdv7vigeiuk9xqLuacdy0d