Re: enregistrements et tableau

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