Re: [firebird-support] Partial update

Den 13.02.2017 20:40, skrev Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]: > Hello, All. > > If I use prepared statement like this "update table set field1=?, > field2=? where > field3=?" for performance reasons, is there a way to update only some fields > and leave > other

RE: [firebird-support] FIREBIRD PIVOT function or Matrix

> > There are times when I would love to be able to pivot data on the > > server, to further process the data an SP. > >SP cannot process queries with unknown number of fields. Neither client > part, BTW. Who said that the number of columns/fields was unknown? I could want to deal with a

Re: [firebird-support] FIREBIRD PIVOT function or Matrix

being an oracle and postrges developer, i tend to (strongly)disagree. it would be great to see some cross tab abilities in firebird. regards zafar From: "Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]" To: firebird-support@yahoogroups.com

Re: [firebird-support] FIREBIRD PIVOT function or Matrix

14.02.2017 16:31, 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] wrote: > There are times when I would love to be able to pivot data on the server, to > further > process the data an SP. SP cannot process queries with unknown number of fields. Neither client part, BTW. > Also,

RE: [firebird-support] Partial update

> > Is that the real issue, you want to eliminate the "prepare" stage? > >"Prepare" does much more than just parsing of query and building plan. It > also check for permissions and this stage cannot be cached. Not if the cache was in the context of the current connection, so permissions

Re: [firebird-support] Partial update

14.02.2017 16:21, 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] wrote: > If you are using UPDATE, then is it not reasonable to expect that you would > know what the > original values for of each field? It is not reasonable: I have no way to know them. All I have at hand is new

RE: [firebird-support] Partial update

>If I use prepared statement like this "update table set field1=?, field2=? > where field3=?" for performance reasons, is there a way to update only > some fields and leave other untouched without overhead of building > separate queries on the fly or selecting old values with different

RE: [firebird-support] FIREBIRD PIVOT function or Matrix

> > Any suggestions on my DB design and query to display the values in matrix > (pivot) format? > >Simple client-side code can show you the matrix in any convenient form. > There is no point to do that on server. I disagree! There are times when I would love to be able to pivot data on

Re: [firebird-support] FIREBIRD PIVOT function or Matrix

14.02.2017 14:15, 'Stef' s...@autotech.co.za [firebird-support] wrote: > Any suggestions on my DB design and query to display the values in matrix > (pivot) format? Simple client-side code can show you the matrix in any convenient form. There is no point to do that on server. -- WBR,

[firebird-support] FIREBIRD PIVOT function or Matrix

Hi all, I don't see a PIVOT function available in Firebird 2.5 What would be the best way to design and query a matrix in firebird. I need a distance matrix to indicate the distance between several cities. Cities will be need to be added and distances adjusted as time goes by. Any