1:16p
Dear all,
How is that I can alter the datatype of the column .
-
Warm Regards
Shÿam Peri
II Floor, Punja Building,
M.G.Road,
Ballalbagh,
Mangalore-575003
Ph : 91-824-2451001/5
Fax : 91-824-2451050
DISCLAIMER: This message contains privileged and confidential information and is
inten
5:08p
Dear All,
When I am executing any function with parameter.. I am unable to access them. So, I
would be thankful if, anyone can help me in teaching this aspect.
CREATE FUNCTION add_one (integer) RETURNS INTEGER AS '
BEGIN
RETURN $1 + 1;
END;
' LANGUAGE 'plpgsql';
The expected
Hey,
PostgreSQL 7.3 on i686-pc-linux-gnu, compiled by GCC 2.96
But, I am getting error when I am using the alias key word.
And also when I try to create a C function for the same and excute I am getting the
following error
ERROR: Memory exhausted in AllocSetAlloc(677865842)
And, I am allocating
Hey,
create or replace function sample(varchar,int) returns varchar as'
declare
data alias for $1;
size alias for $2;
begin
return substr(data,(length(data)-size)+1,length(data));
end;
' language 'plpgsql';
WARNING: plpgsql: ERROR during compil
August 26th 2003
12:31p
Thank you for the quick response.., can u plz tell me how can I do that in db2 also..
Have a grate day
-
Warm Regards
Shÿam Peri
II Floor, Punja Building,
M.G.Road,
Ballalbagh,
Mangalore-575003
Ph : 91-824-2451001/5
Fax : 91-824-2451050
DISCLAIMER: This message c
August 26th 2003
11:30p
How do I get the required number of rows thru a query..
I mean...If I want to show 10 tuples per page.. instead of getting all the tuples from
the relation and do some front end manipulation, is there any way by which I can get
only 10 required tuples from the relation
Ha
August 19th 2003
4:36p
Dear All,
I wanted to know how can I migrate all my data including the schema and their
definitions,from IBM's db2 to the postgres.
Have a grate day
-Warm RegardsShÿam PeriII Floor, Punja
Building,M.G.Road,Ballalbagh,Mangalore-575003 Ph : 91-824-2451001/5Fax :
91-
