[GENERAL] making multiple updates use indexes: howto?

2003-07-07 Thread Pedro Alves
Hi. I have a doubt: If I make: update stockline set status=3 where id IN (select id from lap_mpdetail_view where lap=3976) postgres makes an Seq Scan on stockline. when stockline is big, it is better to make an select id from lap_mpdetail_view where lap=3976) and progr

Re: [GENERAL] upper case constraint?

2001-09-25 Thread Pedro Alves
One turnarround solution I use for that is to make the convertion to uppercase in the script prior to the insertion. If that is your case, u can do that too. Nevertheless, it seem easy to make a function toupper(), if it does not exists yet On Tue, Sep 25, 2001 at 12:43:58PM -0400, Gowe