Yeah, and that is that i hda in mind. Problem is that almost always it is
postgres user, cause it is recommended. Due to protection reasons, some kind
:-).
Andrzej Schulz
Galileo Selidor
- Original Message -
From: "Robert Treat" <[EMAIL PROTECTED]>
To: "Jaskier" <[EMAIL PROTECTED]>
Cc: <[E
I just fall back a little from this suggestion. The database type of 7.2
and 7.3 is different. Just an upgrade will make the old database useless.
U need to backup the database, upgrade and then restore manually.
-vimala/.
On 19 Sep 2003, Robert Treat wrote:
> I didn't see any responses... I
[EMAIL PROTECTED] writes:
> CREATE FUNCTION add_one (integer) RETURNS INTEGER AS '
> BEGIN
> RETURN $1 + 1;
> END;
> ' LANGUAGE 'plpgsql';
> The expected ouput of the above function should be 11 when we pass the 10 t=
> o it but it returns 1.
Works fine for me:
regression=# CR
I have a US zip code look-up table that includes all zip codes within a 300 mile radius.
DATE_PORTAL=# select count(origin) from zips_300 ; count --- 201021979(1 row)
The row count is shown above. I get great , great performance. However with large data sets, you need a lot of spa
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
[EMAIL PROTECTED] a écrit :
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: pl
