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

2005-02-16 Thread Richard Gintz
Pardon me ya'll, but can you tell me what a saisies is? Thanks, Dick -- Richard Gintz Airlink Systems 7600 Burnet Rd. Suite 515 Austin, TX 78757 PH: 512-231-1240 x108 FX: 512-231-9884 EM: [EMAIL PROTECTED] Quoting Marc SCHAEFER [EMAIL PROTECTED]: Hi, I use a FOR one_row IN loop where

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

2005-02-16 Thread Geoffrey
Richard Gintz wrote: Pardon me ya'll, but can you tell me what a saisies is? More than one saisy??? -- Until later, Geoffrey ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's

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

2005-02-16 Thread PFC
French verb saisir : here, to enter data in a system by typing it. noun saisie : the action of doing so. It has other meanings : Saisir : - (commonly) to grab or get hold of something swiftly - (sometimes) to understand something - (lawspeak) that is also what the Oracle layers

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

2005-02-13 Thread Marc SCHAEFER
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.

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

2005-02-13 Thread Tom Lane
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 would