2009/10/23 Andrew Hall :
> Hi Pavel,
>
> many thanks for the very prompt reply.
>
> I was under the impression that a refcursor was a pointer to a dataset
> already resident on the database, and were used to return a reference to a
> dataset resident in the database to a client application.
>
> Wha
Hi Pavel,
many thanks for the very prompt reply.
I was under the impression that a refcursor was a pointer to a dataset already
resident on the database, and were used to return a reference to a dataset
resident in the database to a client application.
What I am trying to do is build a tab
Hello
2009/10/23 Andrew Hall :
> Hi,
>
> I was wondering whether anybody would be able to advise me on how (if it is
> possible) to port some functionality from Oracle?
>
> This is just an example - in Oracle, I am able to do the following
>
Use refcursor, please.
http://www.postgresql.org/docs/
Hi,
I was wondering whether anybody would be able to advise me on how (if it is
possible) to port some functionality from Oracle?
This is just an example - in Oracle, I am able to do the following
--
-- Create a data type which replicates the data structure of a single user in
my application
Pavel Stehule wrote:
> So the
> programming based on returning state codes is very obsolete, and
> little bit difficult. You can emulate, but any protected block creates
> inner transaction and this should negative effect on speed - and it
> are some lines more.
I'd like to second and emphasise t
