On Thu, Mar 06, 2003 at 06:25:29PM -0500, Mark Mitchell wrote:
> I have a Perl program that executes PostgreSQL queries through DBI.
> Is there any way to cancel a query once its started. If I could at least
> somehow get the PID of the child process postmaster starts I could kill
> that.
>
> This
I have a Perl program that executes PostgreSQL queries through DBI.
Is there any way to cancel a query once its started. If I could at least
somehow get the PID of the child process postmaster starts I could kill
that.
This may be a better question for the Perl programming list but I
thought I'd a
Aspire,
> 2. Can we use array for the above thing as
> a. Make an array of the valid roll_numbers. such as
> ('IDX'=>'ROLL_NUMBER')
> b. Now select the array element by the index which will produce the
> roll_number and work on it.
> c. Array could be build by for loop
>
When does count(*) returns "o rows" ?
and when does it return 1 row value being 0.
tradein_clients=# SELECT count(*) from public.eyp_listing where sno> 0 and
amount> 0 group by sno,branch,edition having count(distinct userid) > 1 ;
count
---
(0 rows)
tradein_clients=#
tradein_clients=#
