Re: Are SQL functions better than PG/SQL ones?

I see. I'll redirect the question there then. Thanks.

On Fri, 16 Jul 2004 23:32:13 -0500, mike g <mike(at)thegodshalls(dot)com> wrote:
> Have you run the analyze function on the table or database?
>
> We would need to see the sql for your tests to determine why it was or
> was not used.
>
> By the way the pgsql-performance list is probably a much better place to
> discuss this.
>
> Mike
>
> On Sat, 2004-07-10 at 05:57, Vitaly Belman wrote:
> > I ready somewhere that PostgreSQL is able to optimize SQL functions,
> > the same way it does with views. For example if you do:
> >
> > select * from cv_customers() order by customer_id;
> >
> > When customers is an SQL function the optimizer/planner will be able to
> > actually use the customer_id index.
> >
> > >From some tests I made it doesn't seem true.. Yet I am asking to know
> > for sure.
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 7: don't forget to increase your free space map settings
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>

--
ICQ: 1912453
AIM: VitalyB1984
MSN: tmdagent(at)hotmail(dot)com
Yahoo!: VitalyBe