Re: [SQL] Question on triggers and plpgsql

2005-04-09 Thread Tom Lane
Carlos Moreno <[EMAIL PROTECTED]> writes: > My question is: can I use createlang on a database that is > currently active? That is, a database with plenty of tables > that has been and is currently in use? Sure. regards, tom lane ---(end of broad

Re: [SQL] Question on triggers and plpgsql

2005-04-09 Thread Carlos Moreno
I think I sent my previous message to John only (sorry!) I just wanted to double check one detail that is not explicitly stated in the documentation for createlang. My question is: can I use createlang on a database that is currently active? That is, a database with plenty of tables that has bee

Re: [SQL] subselect query time and loops problem

2005-04-09 Thread Tom Lane
pankaj naug <[EMAIL PROTECTED]> writes: > Both servers have same version with same postgresql.conf. But the time taken > by both the servers with subselect are way different. the loops and the query > time are completely different. both servers have same indexes. Evidently one has been analyzed

[SQL] subselect query time and loops problem

2005-04-09 Thread pankaj naug
hi,   I am using this query.   SELECT * FROM guild_properties_buy WHERE agent IN (SELECT agent_id FROM guild_agents WHERE   address_region = 'midlands'  AND  active='on' AND status=0) AND   country = 'United Kingdom' AND   active='on' AND status='0' ORDER BY price DESC LIMIT 10 OFFSET 0   when i r

Re: [SQL] getting count for a specific querry

2005-04-09 Thread John DeSoi
On Apr 9, 2005, at 11:43 AM, Bob Henkel wrote: Forms also offers a button that say get hit count. So if you really need to know the record count you can get it without moving off the current record. That's a good idea too. Maybe in my interface you could click on the ? to get the count without c

Re: [SQL] getting count for a specific querry

2005-04-09 Thread Bob Henkel
On Apr 9, 2005 10:00 AM, John DeSoi <[EMAIL PROTECTED]> wrote:On Apr 8, 2005, at 3:37 PM, Joel Fradkin wrote:> I don't think my clients would like me to aprox as it is a count of> their> records. What I plan on doing assuming I can get all my other problems> fixed> (as mentioned I am going to try a

Re: [SQL] getting count for a specific querry

2005-04-09 Thread John DeSoi
On Apr 8, 2005, at 3:37 PM, Joel Fradkin wrote: I don't think my clients would like me to aprox as it is a count of their records. What I plan on doing assuming I can get all my other problems fixed (as mentioned I am going to try and get paid help to see if I goofed it up some where) is make th