Re: [BUGS] Postgresql 7.3.2-3 and 7.3.3-4 freeze

2003-07-17 Thread Tom Lane
"Admin Gaston" <[EMAIL PROTECTED]> writes: > CREATE FUNCTION alta_usuario(varchar, varchar, varchar, varchar, varchar, v= > archar, smallint, smallint, date, smallint, varchar, varchar, smallint, var= > char, varchar, varchar, varchar, varchar, smallint, varchar, smallint, varc= > har) RETURNS int4

Re: [BUGS] Postgresql 7.3.2-3 and 7.3.3-4 freeze

2003-07-17 Thread Richard Hall
Instead of Comprueba = (SELECT "Usu_ID" FROM "Users" WHERE LOWER("Usu_Nick") = LOWER(xUsu_Nick) ); use SELECT "Usu_ID" INTO Comprueba FROM "Users" WHERE LOWER("Usu_Nick") = LOWER(xUsu_Nick) Rick ---(end of broadcast)--- TIP 6: Have you s

[BUGS] Postgresql 7.3.2-3 and 7.3.3-4 freeze

2003-07-17 Thread Admin Gaston
Hi, first of all i don't speak english very good. I make a function in pl/pgsql, that cause a denial of service. The function has a simple select. If anyone can help with this.  create table "Users" ("Usu_ID" int, "Usu_Nick" varchar(32), "Usu_Apellido" varchar(50), "Usu_Nombre" varchar(50),