Postgres Pro
Downloads
Home   >   mailing lists

Re: storED procedures - Mailing list pgsql-general

From Tom Lane
Subject Re: storED procedures
Date
Msg-id 27769.973813810@sss.pgh.pa.us
Whole thread Raw
In response to Re: storED procedures  (Nelio Alves Pereira Filho <nelio@ifx.com.br>)
List pgsql-general
Tree view 
Nelio Alves Pereira Filho <nelio@ifx.com.br> writes:
> The only thing is that view don't implement unions, but I can do union
> of views instead.

Views containing unions work in current sources (7.1-to-be).

BTW, views containing GROUP BY and/or aggregates are pretty flaky in
current releases; be wary when using one.  Also fixed for 7.1.

            regards, tom lane

pgsql-general by date:

Previous
From: "Edward Q. Bridges"
Date:
Subject: RE: NVL (sql oracle)
Next
From: Gunnar R|nning
Date:
Subject: Re: Full text searching?