[SQL] Order of columns in a table important in a stored procedure?

Hi, I use a FOR one_row IN loop where one_row is of type saisies%ROWTYPE. The loop does a SELECT on a table, bennes, changing a few values. The idea is that the function should return some bennes rows, but with additional information, which makes the returned rows a saisies table-like row set. I

Re: [SQL] Order of columns in a table important in a stored procedure?

Marc SCHAEFER <[EMAIL PROTECTED]> writes: > I have however noticed that if the SELECT is *NOT* in the correct order > for the table saisies, funny errors happen (such as type constraints -- > obviously columns are mixed). > What I do not understand is that I use AS in order to name the columns, > I

[SQL] XML

Title: XML I need help in getting the xml contribution installed. I have installed the contrib package for Postgres 7.4.5 and would appreciate any guidance as to how I get this working? Theo __ This email, including attac

[SQL] Working with XML.

Title: Working with XML. Hi Folks, Is there a way to pass in an xml string into a stored proc and thenplace this into a temp table? I use to be able to do this in sql server, it was quite handy as I could call one stored proc to update multiple records, here is a sample in sql server: se