From: | "Dr(dot) Stephane Schildknecht" <sschildknecht(at)linagora(dot)com> |
---|---|
To: | "Froggy / Froggy Corp(dot)" <froggy(at)froggycorp(dot)com> |
Cc: | "FERREIRA William (COFRAMI)" <william(dot)ferreira(at)airbus(dot)com>, "pgsql-fr-generale(at)postgresql(dot)org" <pgsql-fr-generale(at)postgresql(dot)org> |
Subject: | Re: enregistrements et tableau |
Date: | 2005-02-22 14:55:16 |
Message-ID: | 421B47D4.1030606@linagora.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-fr-generale |
Froggy / Froggy Corp. wrote:
> CF IRC et mon ancien mail, pour recuperer la valeur directe d'un
> tableau, un RAISE NOTICE ''%'', array, suffit.
> Cela sort un truc equivalent a :
> {"","","","","","","","","","","","","","","","",&,"","","","","","","","","
> ","","","","","","",&,"","","","","","","","","","","","","","","",&,"","","
> ","","","","","","","","","","","","",&,"","","","","","","","","","","","",
> "","","",&,"","","","","","","","","","","","","","","",&,"","","","","","",
> "","","","","","","","","",&,"","","","","","","","","","","","","","","",&,
> "","","","","","","","","","","","","","","",&,"","","","","","","","","",""
> ,"","","","","",&,"","","","","","","","","","","","","","","",&,"","","",""
> ,"","","","","","","","","","","",&,"","","","","","","","","","","","","","
> ","",&,"","","","","","","","","","","","","","","",&,"","","","","","","","
> ","","","","","","","",&,"","","","","","","","","","","","","","","",&}
>
> tableau une dimension où chaque entree est delemite par une ',', les "
> delimites les rengistrements null.
> Donc la, on a "array[17] = ''&''".
>
> "Dr. Stephane Schildknecht" wrote:
>
>>Froggy / Froggy Corp. wrote:
>>
>>>pour une dimension je peux aider (je suis en plein dedans), pour du
>>>multidimension c etait assez incertain d apres les derniers reports de
>>>la mail general EN que j avais lu
>>>
>>>en declaration c est :
>>>mavariable varchar[]; pour un tableau de characteres/string
>>>
>>>ensuite il faut l'init avec : (assez incertain d apres les tests fait
>>>par les personnes du channel IRC)
>>>mavariable := ''{}''; (pour une dimension)
>>>mavariable := ''{{}{}}''; (pour deux dimension)
>>>
>>>ensuite pour le remplissage du tableau, un remplissage incrementiel
>>>comme une pile ne pose pas de probleme.
>>>
>>>
>>
>>Eh eh...
>>En effet, j'ai fait les tests avec PG 8.01, et si je n'initialise pas le
>>tableau, je peux le remplir. Le problème, c'est que je ne sais pas avec
>>quoi je le remplis, je n'ai pas encore réussi à extraire la moindre
>>valeur de ce tableau ;-)
>>
>>Stéphane
>
>
>
Y aurait-il un bug dans la gestion des tableaux ?
Visiblement, la fonction de Froggy passe en 7.4, mais pas en 8.0.
--
Stéphane SCHILDKNECHT
LINAGORA
30 rue Saint Augustin 75002 PARIS
Tel : +33(0)1 58 18 68 28
fax : +33(0)1 58 18 68 29
http://www.linagora.com
From | Date | Subject | |
---|---|---|---|
Next Message | Froggy / Froggy Corp. | 2005-02-22 15:26:02 | Re: enregistrements et tableau |
Previous Message | Froggy / Froggy Corp. | 2005-02-22 14:47:28 | Re: enregistrements et tableau |