"Kumar" <[EMAIL PROTECTED]> writes:
> (1) pls have a look in the function, that I have named the cursor as ref1, =
> but again it is returning a unnamed cursor?
This is not a bug. See the "returning cursors" section of the plpgsql
manual. (IIRC, you can also create a named cursor by binding the
On Tuesday 02 September 2003 16:40, you wrote:
> No problem to use a temp table in a trigger (which is local to the
> session), I do so myself. Still, session variables would be nice, making
> coding a little bit more comfortable.
(it would be very good if you implement session variables in Post
Dear Friends,
Using Postgres 7.3.4 over the linux server 7.3.
Is it possible to alter/change the data type of a existing
table's column, with out dropping and recreating a column of same
name.
Thanks for ur knowledge sharing.
Regards
Kumar
- Original Message -
From: rute solipa
To: [EMAIL PROTECTED]
Sent: Thursday, July 31, 2003 9:35 AM
Subject: [SQL] Unsubscribe
Unsubscribe
Dear Friends,
Using Postgres 7.3.4 on Linux 7.3 Server. Using PgAdmin II for
Windows version 1.6.0 to connect to the server from my client
machine.
CREATE FUNCTION selfn() RETURNS refcursor AS 'DECLARE ref1
refcursor;BEGINOPEN ref1 FOR SELECT * FROM
address;RETURN ref1;END;' LANGUAGE '
