Re: enregistrements et tableau

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: Raw Message | Whole Thread | 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

In response to

Responses

Browse pgsql-fr-generale by date

  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