Re: [SQL] puzzled by SELECT INTO

2007-10-31 Thread Gerardo Herzig
Rodrigo De León wrote: On 10/30/07, Gerardo Herzig <[EMAIL PROTECTED]> 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

Re: [SQL] puzzled by SELECT INTO

2007-10-30 Thread Rodrigo De León
On 10/30/07, Gerardo Herzig <[EMAIL PROTECTED]> 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_

[SQL] puzzled by SELECT INTO

2007-10-30 Thread Gerardo Herzig
Hi all. Im having some trouble here that cannot understand. Consider this function: CREATE OR REPLACE FUNCTION read_words(bigint, varchar) returns varchar as $$ declare returnValue varchar ; BEGIN select * into returnValue from array_to_string(array(select word from words where page_id=$1