Re: puzzled by SELECT INTO
От | Gerardo Herzig |
---|---|
Тема | Re: puzzled by SELECT INTO |
Дата | |
Msg-id | 472874E0.4060104@fmed.uba.ar обсуждение исходный текст |
Ответ на | Re: puzzled by SELECT INTO ("Rodrigo De León" <rdeleonp@gmail.com>) |
Список | pgsql-sql |
Rodrigo De León wrote: >On 10/30/07, Gerardo Herzig <gherzig@fmed.uba.ar> wrote: > > >>Wreird enough to me, need some advice plz! >> >> > >CREATE OR REPLACE FUNCTION READ_WORDS(BIGINT, INT[]) >RETURNS VARCHAR >AS >$$ > DECLARE > RETURNVALUE VARCHAR; > BEGIN > SELECT ARRAY_TO_STRING(ARRAY( > SELECT WORD > FROM WORDS WHERE PAGE_ID=$1 > AND WORD_POSITION = ANY ($2) > ), ' ') INTO RETURNVALUE; > RETURN RETURNVALUE; > END; >$$ LANGUAGE PLPGSQL; > >SELECT READ_WORDS(99466, '{2994,2995,2996}'); > >See: >http://www.postgresql.org/docs/8.2/static/arrays.html > > > > Mmmm, yes, that make perfect sense. I did 'resolve' the previous situation by using EXECUTE, i will try your solution now. Gracias Rodrigo. Gerardo
В списке pgsql-sql по дате отправления: