Re: [SQL] SELECT with sum on groups ORDERING by the subtotals

Hi Greg, Thanks for your reply. Yes, same group of code... Perfect solution, simple and efficient. Thank you very much!!! Cheers, Rodrigo Carvalhaes Greg Sabino Mullane wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I need an subtotal for all the products with the same group and

Re: [SQL] how can i UPDATE without dead rows

[EMAIL PROTECTED] wrote: Hi! My program must use UPDATE usualy, and there will be many dead rows in this table what throttle down the db server. I would like to update so not create dead row. How can i do this? You can't - that's how MVCC works. Make sure your free-space-map settings are l

Re: [SQL] UPDATEABLE VIEWS ... Examples?

Dmitri Bichko wrote: > warn "WARNING: dmitrisms are on, some assumptions may not make sense" beauty! :) -- ___ This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of t

[SQL] how can i UPDATE without dead rows

Hi! My program must use UPDATE usualy, and there will be many dead rows in this table  what throttle down the db server. I would like to update so not create dead row. How can i do this? sorry for my english :)

Re: [SQL] substr or char_length problem

On Fri, Jun 17, 2005 at 12:25:28PM +0200, Andreas Kretschmer wrote: > am 17.06.2005, um 13:01:15 +0300 mailte Fatih Cerit folgendes: > > > > I have a problem with function substr or char_length or both. I guery A2 > > and it works fine. But sometimes gives 'ERROR: negative substring length > >

Re: [despammed] [SQL] substr or char_length problem

am 17.06.2005, um 13:01:15 +0300 mailte Fatih Cerit folgendes: > Dear ALL > > I have a problem with function substr or char_length or both. I guery A2 > and it works fine. But sometimes gives 'ERROR: negative substring length > not allowed'. When I test many many times with diffrent values, ne

[SQL] substr or char_length problem

Dear ALL I have a problem with function substr or char_length or both. I guery A2 and it works fine. But sometimes gives 'ERROR: negative substring length not allowed'. When I test many many times with diffrent values, never gives error. Sample table and query below. A1 A2 --