On Fri, Jul 02, 2004 at 09:48:48 +0200,
Peter Alberer <[EMAIL PROTECTED]> wrote:
>
> Postgres seems to execute the function "submission_status" for every row
> of
> the submissions table (~1500 rows). The query therefore takes quite a
> lot
> time, although in fact no row is returned from the as
On Jul 2, 2004, at 3:48 AM, Peter Alberer wrote:
Postgres seems to execute the function "submission_status" for every
row
of
the submissions table (~1500 rows). The query therefore takes quite a
lot
time, although in fact no row is returned from the assignments table
when
the condition package_id=
Hi there,
i have a problem with a query that uses the result of a plsql function
In
the where clause:
SELECT
assignments.assignment_id,
assignments.package_id AS package_id,
assignments.title AS title,
COUNT(*) AS Count
FROM
assignments INNER JOIN submissions ON
(assignments.as