Re: [GENERAL] HELP speed up my Postgres

[Anatoly Okishev]

SQL:
update SUBSCRIPTIONTABLE set ACTIVEFLAG='Y' where mobile_num in (select
mobile_num from LOADED_MOBILE_NUMBERS)
You can try this:
update SUBSCRIPTIONTABLE, LOADED_MOBILE_NUMBERS  set 
SUBSCRIPTIONTABLE.ACTIVEFLAG='Y'
where LOADED_MOBILE_NUMBERS.mobile_num=SUBSCRIPTIONTABLE.mobile_num

Anatoly.

---(end of broadcast)---
TIP 6: Have you searched our list archives?
  http://archives.postgresql.org

Re: [GENERAL] How the function written on pl/pgsql can be called by the function written on plperl.

[Anatoly Okishev]

Anatoly Okishev wrote:
How the function written on pl/pgsql can be called by the function
written on plperl.
Error is:
error from function: Undefined subroutine
&Safe::Root2::get_national_code called.
You probably need to be calling "SELECT get_national_code(...)" to access 
it via a standard query.

--
  Richard Huxton
  Archonet Ltd
If i call this function from pl/pgsql it's worked, but i want to call this 
function from plperl..

Anatoly Okishev

---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
 joining column's datatypes do not match

[GENERAL] How the function written on pl/pgsql can be called by the function written on plperl.

[Anatoly Okishev]

How the function written on pl/pgsql can be called 
by the function written on plperl.
 
Error is:
 
error from function: Undefined subroutine 
&Safe::Root2::get_national_code called.