Re: [SQL] Putting an INDEX on a boolean field?

On 6/17/05, Marc G. Fournier <[EMAIL PROTECTED]> wrote: > On Fri, 17 Jun 2005, Tom Lane wrote: > > > "Marc G. Fournier" <[EMAIL PROTECTED]> writes: > >> Does that make sense? Would it ever get used? > > > > It could get used if one of the two values is far less frequent than the > > other. Perso

Re: [SQL] Putting an INDEX on a boolean field?

On Fri, 17 Jun 2005, Tom Lane wrote: "Marc G. Fournier" <[EMAIL PROTECTED]> writes: Does that make sense? Would it ever get used? It could get used if one of the two values is far less frequent than the other. Personally I'd think about a partial index instead ... Hr, hadn't thought o

Re: [SQL] Putting an INDEX on a boolean field?

how about an very large table with a "processed" type flag? uru -Dave Marc G. Fournier wrote: Does that make sense? Would it ever get used? I can't see it, but figured I'd ask ... Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED]

Re: [SQL] Putting an INDEX on a boolean field?

"Marc G. Fournier" <[EMAIL PROTECTED]> writes: > Does that make sense? Would it ever get used? It could get used if one of the two values is far less frequent than the other. Personally I'd think about a partial index instead ... regards, tom lane --

[SQL] Putting an INDEX on a boolean field?

Does that make sense? Would it ever get used? I can't see it, but figured I'd ask ... Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664 ---(end of broadcast)-

Re: [SQL] Still getting autoreplies from list member

On Friday 17 Jun 2005 8:46 am, Michael Fuhr wrote: > The autoreplies mentioned in these threads are still happening: > > http://archives.postgresql.org/pgsql-sql/2005-06/msg00102.php > http://archives.postgresql.org/pgsql-sql/2005-06/msg00097.php > > I can tweak my filters to drop the autoreplies,

Re: [SQL] Still getting autoreplies from list member

I'll just second that this is, in fact, extremely annoying. Dmitri -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael Fuhr Sent: Thursday, June 16, 2005 11:16 PM To: pgsql-sql@postgresql.org Subject: [SQL] Still getting autoreplies from list member

[SQL] Still getting autoreplies from list member

The autoreplies mentioned in these threads are still happening: http://archives.postgresql.org/pgsql-sql/2005-06/msg00102.php http://archives.postgresql.org/pgsql-sql/2005-06/msg00097.php I can tweak my filters to drop the autoreplies, but shouldn't this person either fix their mail configuration

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

On Thu, Jun 16, 2005 at 06:05:03PM -0300, Marc G. Fournier wrote: > > Reading through the docs, both the CREATE VIEW and CREATE RULE pages refer > to how you can use a RULE to 'simulate' an updateable VIEW ... but I can't > seem to find any examples of this ... Are you looking for "Cooperation

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

Here's one I did a while ago; the tables are trivial in this case (and the whole thing is definitely overkill) so it should make it easier to digest. This becomes useful if you use some sort of ORM layer (Class::DBI in my case) that can be made to recognize the 'type' column and behave polymorphic

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

There is a write up on these at: http://www.varlena.com/GeneralBits/82.php --elein [EMAIL PROTECTED]Varlena, LLCwww.varlena.com PostgreSQL Consulting, Support & Training PostgreSQL General Bits http://www

[SQL] UPDATEABLE VIEWS ... Examples?

Reading through the docs, both the CREATE VIEW and CREATE RULE pages refer to how you can use a RULE to 'simulate' an updateable VIEW ... but I can't seem to find any examples of this ... Does anyone know of an online example of doing this that I can read through? Thanks ... Marc G.

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

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > I need an subtotal for all the products with the same group and that the > query be ordered by the bigger subtotal. (please proofread: the subtotals in your example output did not add up) By "same group" I presume you mean the same code, as you d

Re: [SQL] SELECT very slow

On 16.06.2005 17:29 PFC wrote: >> If autocommit is on (or fetch size is zero) then the driver will >> build the whole >> result set before returning to the caller. > > > Sure, but that is not your problem : even building the whole result > set should not take longer than a few seconds (I g

Re: [SQL] SELECT very slow

If autocommit is on (or fetch size is zero) then the driver will build the whole result set before returning to the caller. Sure, but that is not your problem : even building the whole result set should not take longer than a few seconds (I gave you test timings in a previous message).

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

Hi Gnanavel, Thanks for your promptly answer. Yes, your solution solves this problem BUT the point is that I don't wanna a solution that works only if the codes are in desc order. For example, if the codes are on the order above: INSERT INTO test (code, description, quant, price, total) VALUE

Re: [SQL] PostgreSQL and Delphi 6

Hi Adrian! Yes, the user have to wait until the refresh finishes... That's a problem but we didn't found any other solution... Regards, Rodrigo Carvalhaes Din Adrian wrote: I am sorry - I don't understand (or my english is bad or I don't know what you mean). What we did was include one

Re: [SQL] cursor "" does not exist

On Wed, Jun 15, 2005 at 06:45:56PM -0400, Vsevolod (Simon) Ilyushchenko wrote: > While those that fail look like this: > > Request select * from material_pkg.ListCautions_fcn($1,$2) as result B > Response result C SELECT > > Note that the successful ones contain strings "S_1" and "BEGIN", and th

Re: [SQL] SELECT very slow

On 16.06.2005 16:00 Scott Marlowe wrote: > There's got to be more happening than what this is showing us. A > select, and looping through it, should involve no writes, and therefore > no real performance difference from autocommit versus not. Is there > some underlying trigger on the view or som

Re: [SQL] funny update, say update 1, updated 1 added 2nd.

works fine for me. Do you have any triggers on the tables or other rules? Can you provide a complete SQL script that starts from an empty database. Jim -- Original Message --- From: Neil Dugan <[EMAIL PROTECTED]> To: pgsql-sql@postgresql.org Sent: Thu, 16 Jun 2005 13:38:58 +1

Re: [SQL] SELECT very slow

On Wed, 2005-06-15 at 17:08, Thomas Kellerer wrote: > PFC wrote on 15.06.2005 22:04: > > > > >> It's not the program or Java. The same program takes about 20 seconds > >> with Firebird and the exactly same data. > > > > > > Hm, that's still very slow (it should do it in a couple seconds l

Re: [SQL] PostgreSQL and Delphi 6

I am sorry - I don't understand (or my english is bad or I don't know what you mean). What we did was include one "refresh" button and inserted one configuration that after x seconds the component refresh the screen (query). So: When the user push the 'post' button the driver automatical

Re: [SQL] PostgreSQL and Delphi 6

Hi Adrian, You're right. What we did was include one "refresh" button and inserted one configuration that after x seconds the component refresh the screen (query). If you find a better solution, please inform me. Regards, Rodrigo Din Adrian wrote: We tested also (pgExpress Driver) - is fa

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

This might work, select * from (SELECT * FROM product_sales()) t order by t.code desc,t.subtotal; with regards, S.Gnanavel > -Original Message- > From: [EMAIL PROTECTED] > Sent: Thu, 16 Jun 2005 10:07:15 -0300 > To: [EMAIL PROTECTED], pgsql-sql@postgresql.org > Subject: Re: [SQL] SELECT

Re: [SQL] PostgreSQL and Delphi 6

We tested also (pgExpress Driver) - is faster then psqlodbc but we have a problem with it: it does requery (or refresh? - I don't remember exactly) after every post in database.(for us this is a problem - if you have more then 10.000 in current dataset loaded when you add a new record and pos

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

Hi ! This is not possible because the query will have a time interval and the subtotal will change due the intervals passed to the query... To get the subtotal I already know how to do it (see below) but the problem is get the correct output, ordering by the bigger totals agrouped by product c

Re: [SQL] PostgreSQL and Delphi 6

Hi J! We use here vitavoom from Steve Howe (www.vitavoom.com). It's a very good and native alternative. It's paid but not expensive and you will have a very good and qualified technical supporte. Regards, Rodrigo Carvalhaes Postgres Admin wrote: I have a client who wants to use Delphi as

Re: [SQL] Function does not return, but gives error..

my bad: please forget my previous mail, I tested it with a filled group, which is of course not empty... the solution was correct, thanks! Gnanavel Shanmugam wrote: -Original Message- From: [EMAIL PROTECTED] Sent: Thu, 16 Jun 2005 14:26:39 +0200 To: pgsql-sql@postgresql.org Subject: [S

Re: [SQL] Function does not return, but gives error..

On Thu, Jun 16, 2005 at 02:26:39PM +0200, M.D.G. Lange wrote: > > IF groupres = NULL > THEN > ... > END IF; > is not trapped... Be sure to understand how NULL works in comparisons: http://www.postgresql.org/docs/8.0/static/functions-comparison.html SELECT NULL = NULL; ?column? -- (1

Re: [SQL] Function does not return, but gives error..

Gnanavel Shanmugam wrote: -Original Message- From: [EMAIL PROTECTED] Sent: Thu, 16 Jun 2005 14:26:39 +0200 To: pgsql-sql@postgresql.org Subject: [SQL] Function does not return, but gives error.. I have the following function to determine wether or not a user is member of a group, howe

Re: [SQL] Function does not return, but gives error..

> -Original Message- > From: [EMAIL PROTECTED] > Sent: Thu, 16 Jun 2005 14:26:39 +0200 > To: pgsql-sql@postgresql.org > Subject: [SQL] Function does not return, but gives error.. > > I have the following function to determine wether or not a user is > member of a group, however I have a sma

Re: [SQL] PostgreSQL and Delphi 6

Yes, the client must have the psqlodbc driver and mdac at least 2.6. (Mdac2.5 is verry buggy - attention win2000 and win9x must be upgraded if you need mdac for your app). When using server side cursors for a dataset the update and delete functions act 'strange' as not refreshing corect the

[SQL] Function does not return, but gives error..

I have the following function to determine wether or not a user is member of a group, however I have a small problem with it: a group without members results in groupres being NULL (I have checked this), however IF groupres = NULL THEN ... END IF; is not trapped... I have tried to use array_uppe

Re: [SQL] PostgreSQL and Delphi 6

So you installed psqlodbc 8 on the client machine with Delphi installed, correct? What problems did you have with cursors? Any other suggestions? Thanks a lot for the help! J Din Adrian wrote: > we are using postgresql8 +psqlodbc8+ delphi7 ... the only problem is > the server side cursor = doe

[SQL] funny update, say update 1, updated 1 added 2nd.

I have been having some trouble with a particular table view. An UPDATE command is not only changing the applicable record it is also creating a new record as well. wholesale=# select * from accounts_supplier; id | name | contact | addr| addr2 | town | postcode | st

Re: [SQL] PostgreSQL and Delphi 6

we are using postgresql8 +psqlodbc8+ delphi7 ... the only problem is the server side cursor = doesn't work properly ... so we are using client side for datasets :) On Wed, 15 Jun 2005 23:49:29 -0400, Postgres Admin <[EMAIL PROTECTED]> wrote: I have a client who wants to use Delphi