-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi
I have written the following function but it's isn't returning anything when I run it. Can somebody help identify the issue?
CREATE OR REPLACE FUNCTION GenerateReadableRandomString (
len INT
)
RETURNS varchar
AS
$$
DECLARE
validchars VARCHAR;
randomstr VARCHAR;
randint INT;
…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hello there,
When assigning mobilenumbers to a varchar[] in a loop through results it gives me the following error:
"array subscript in assignment must not be null"
Also, i think the query that joins member uuids, and group member uuids, into one, grouped on the user_id, i think it can be done…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Do the following scheme for my database:
create sequence data_sequence;
create table data_table
{
id integer primary key;
field varchar(100);
};
create view data_view as
select id, field from data_table;
create function data_insert(_new data_view) returns data_view as
$$declare
_id…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I want to do something like this in PostgreSQL.
I tried this:
CREATE or replace FUNCTION create_patient(_name text, _email text, _phone text, _password text, _field1 text, _field2 text, _field3 timestamp, _field4 text, OUT _pid integer, OUT _id integer) RETURNS record AS $$
DECLARE
_id…
>>> More
-
as seen on Developper.com
- Search for 'Developper.com'
Bonjour,
voici le premier d'une nouvelle série d'articles consacrés au développement des fonctions sous PLpgSQL
Ce premier article est consacré aux fonctions scalaires appelées dans la norme SQL "UDF" pour User Defined Function
Il sera suivi dans les mois prochains de deux autres…
>>> More