Is there anyway to return a recordset from a Stored Procedure in Postgres so that it
can be used as a type of view or select?
I know that you can do this in Interbase or MS-SQL.
I have seen that you can return a complete record but that's not really the same thing.
Marc Rohloff
Marc,
Marc Rohloff wrote:
> Is there anyway to return a recordset from a Stored Procedure in Postgres so that it
>can be used as a type of view or select?
In short:-
No, there isn't.
More detail:-
PostgreSQL does not have stored procedures as such, it has user defined functions.
The
On Mon, 6 Nov 2000, Grant Finnemore wrote:
> Whilst this is an unfortunate position at the moment, it has been my experience that
>it does not cause insurmountable problems.
> (Some short term headaches - yes. ;-)
After learning this as a fact you have short term headaches but before
you have co
Andreas Tille wrote:
> On Mon, 6 Nov 2000, Grant Finnemore wrote:
>
> > Whilst this is an unfortunate position at the moment, it has been my experience
>that it does not cause insurmountable problems.
> > (Some short term headaches - yes. ;-)
> After learning this as a fact you have short term h
Hi,
I would like to know if someone have a solution for me ...
I have a table with today about 2,8 millions records.
The table have good indexes, in our case on idcond, and points !
When I do :
select sum(points) from gains;
With Oracle : 8 sec
With PostGreSQL : 10 sec
OK for this it's ok ...
Hi all,
I am part of the team that's porting the ArsDigita Community System
(ACS), a toolkit to create community-oriented db-backed websites, from
Oracle to PostgreSQL. We call the projet OpenACS.
We are thinking of using PG 7.1b for the port (since it'll take some
time, a
Greetings.
We three have three tables, a links table which stores basic information
about a link, a linksdetail table which stores more detailed information
about the link, and a linkdaystats table which records the daily statistical
information on the link.
My problem is, once a day I want to
Roberto Mello <[EMAIL PROTECTED]> writes:
> I was wondering if UNIONs in VIEWS will be supported too.
Already there for 7.1.
regards, tom lane
