Re: Query - Mailing list pgsql-admin

From Stephan Szabo
Subject Re: Query
Date
Msg-id Pine.BSF.4.21.0108240904330.22775-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Query  (Vida Luz Arista <vlal@ideay.net.ni>)
List pgsql-admin

On Fri, 24 Aug 2001, Vida Luz Arista wrote:

> Hi All, I have two questions
>
> 1- I have a query but this is very slow, I need to acelerate the
> consult, this result sill be show in the web.
>
> My query is:
>
> select user, descripcion from client where login not in (select
> distinct(usr_cliente) from conexion where fecha between '$date_begin' and
> '$date_end') order by user"

See FAQ entry 4.23.  Short form is convert the query to use EXISTS rather
than IN.


> 2- I made this function:
>
> CREATE FUNCTION list(date,date) RETURNS user
>      AS 'select distinct(usr_cliente) from conexion where fecha between
>         $date_begin and $date_end' LANGUAGE 'sql';
>
> When I execute a query to this function like:
> select select listado('08-10-2001', '08-13-2001') as user;
>
> the result is just 1 row, however If I to execute the query this return
> 300 rows, why the function only return one row?

I think you'd need to say setof user as the return type, although I'm not
100% sure that'll give you back something meaningful (It gives me
something meaningful on my 7.2 devel machine, but I don't have an earlier
system to test on)



pgsql-admin by date:

Previous
From: Richard Bayet
Date:
Subject: Re: Query
Next
From: "Ted Rolle"
Date:
Subject: Fast load