Hello,
Sorry for just stupid question, but I need use md5 function in 7.4
When I write:
select md5('text');
ERROR: Function md5("unknown") does not exist
Unable to identify a function that satisfies the given argument types
You may need to add explicit typecasts
where is problem?
hello,
it is possible to write something similar???
create function get_count(varchar(32)) RETURNS int4 AS '
DECLARE
tmp int4;
BEGIN
SELECT COUNT(*) INTO tmp FROM $1;
RETURN tmp;
END;' LANGUAGE 'plpgsql';
SELECT get_count('k_part');
SQL error:
ERROR: parser: parse error at or near "$1" a
Hi,
I develop web application. My case model consists of many tables. I
have VIEW through the 5 tables and 4 JOINs.
first table has 14000 rows, second 42000 rows and others have around
20 rows.
Time of query depends on WHERE condition.
SELECT COUNT(*) FROM v_auto_detail_seller; takes time 1 sec.
Hello,
I need to create user defined variable in every database session.
In Sybase ASA is equivalent:
CREATE VARIABLE name TYPE;
I need use this in views. Is it possible???
thanx, miso
---(end of broadcast)---
TIP 3: if posting/reading through Us
