From: | "Froggy / Froggy Corp(dot)" <froggy(at)froggycorp(dot)com> |
---|---|
To: | "Dr(dot) Stephane Schildknecht" <sschildknecht(at)linagora(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:47:28 |
Message-ID: | 421B4600.C170785D@froggycorp.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-fr-generale |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Dr. Stephane Schildknecht | 2005-02-22 14:55:16 | Re: enregistrements et tableau |
Previous Message | Dr. Stephane Schildknecht | 2005-02-22 14:42:28 | Re: enregistrements et tableau |