Re: [GENERAL] help about the function

2005-06-23 Thread Zlatko Matić
Great! It works. Thanks. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] ; [EMAIL PROTECTED] Cc: pgsql-general@postgresql.org Sent: Thursday, June 23, 2005 10:18 AM Subject: Re: [GENERAL] help about the function Hi, Why not

Re: [GENERAL] help about the function

2005-06-23 Thread Patrick . FICHE
Hi, Why not :   SELECT INTO l_validity "VALIDITY"."VALIDITY" FROM ( SELECT min("VALIDITY"."RV_ID") AS "RV_ID", "VALIDITY"."VALIDITY" FROM "VALIDITY" GROUP BY "VALIDITY"."RV_ID", "VALIDITY"."VALIDITY") sve;   Regards, Patrick  

[GENERAL] help about the function

2005-06-23 Thread Zlatko Matić
Hello!   I have implemented solution for enabling regular user (from group "ADMINS") to create new users in predefined groups, by your modified function:   CREATE OR REPLACE FUNCTION "public"."alter_group" (name, boolean, name, varchar, timestamp) RETURNS boolean AS$body$DECLARE  l_group ALI