Re: [GENERAL] How much lines per day?

2009-10-21 Thread Rakotomandimby Mihamina
10/21/2009 08:40 AM, Tatsuo Ishii: Does anyone know such number? With some script binding the PG SCM you could easily find that. It's all about SUMming "--" and "++" from commit diffs. -- Architecte Informatique chez Blueline/Gulfsat: Administration Systeme, Recherche & Developpement

[GENERAL] [OT] Relocation lookup

2009-10-01 Thread Rakotomandimby Mihamina
Hi all, Given the Social and Political reality in my country (Madagascar), I am obliged to look for a relocation. This is my public profile: http://www.linkedin.com/in/mihaminarakotomandimby Would you be aware of a position I could fit in? Thank you. -- Architecte Informatique chez Blueli

Re: [GENERAL] ERROR: invalid input syntax for integer: ""

2009-09-25 Thread Rakotomandimby Mihamina
09/25/2009 01:55 PM, Grzegorz Jaƛkiewicz: and what's the error message ? ERROR: invalid input syntax for integer: "" (I put it in the email subject, not very clever from me) -- Architecte Informatique chez Blueline/Gulfsat: Administration Systeme, Recherche & Developpement

[GENERAL] ERROR: invalid input syntax for integer: ""

2009-09-25 Thread Rakotomandimby Mihamina
Hi all, I get invalid input syntax when UPDATEing my radacct table: freedsl=# \d radacct Table "public.radacct" Column| Type | Modifiers --+--+

Re: [GENERAL] return multiple rows

2009-09-11 Thread Rakotomandimby Mihamina
09/11/2009 05:53 PM, Rakotomandimby Mihamina: Is SELECTing INTO a second time OK? But I dont know how... Any hint? -- Architecte Informatique chez Blueline/Gulfsat: Administration Systeme, Recherche & Developpement +261 34 29 155 34 -- Sent

[GENERAL] return multiple rows

2009-09-11 Thread Rakotomandimby Mihamina
Hi all, I have a FUNCTION queried like this: SELECT * FROM f_authorize_check_query2('%{SQL-User-Name}','%{User-Password}' [...]; Built this way: CREATE FUNCTION f_authorize_check_query2(...) RETURNS radcheck AS $_$ DECLARE [...] v_ret radcheck%ROWTYPE; [...]

[GENERAL] edit function

2009-09-06 Thread Rakotomandimby Mihamina
Hi all, On a PostGreSQL 8.1 (Debian Etch) I have a function like this: CREATE FUNCTION f_active_client(character varying) RETURNS character varying AS $_$ DECLARE v_modem ALIAS FOR $1; v_firstuse BOOLEAN; v_admactive BOOLEAN; v_codeclt varchar; BEGIN SELECT INTO (...)