Thread: basic function not working
Hi, could somebody tell me what I'm missing here? Postgres appears to not know where to look for the table I am using in my SELECT INTO clause because the error says it iscoming before the FROM word. ============================================ the function is: SET search_path = public; CREATE or replace FUNCTION user_tablere (text) RETURNS text AS ' DECLARE -- Declare aliases for function arguments. location_in ALIAS FOR $1; username text; BEGIN SELECT into username FROM user_table WHERE location = location_in; return username; END; ' LANGUAGE 'plpgsql'; ============================================ which gives this out: Welcome to psql 7.3.1, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help on internal slash commands \g or terminate with semicolon to execute query \q to quit address=# \e a_a.sql SET CREATE FUNCTION address=# select user_tablere('sacu'); WARNING: Error occurred while executing PL/pgSQL function user_tablere WARNING: line 12 at select into variables ERROR: parser: parse error at or near "FROM" at character 9 address=# ============================================ -- joe speigle
joseph speigle <joe.speigle@jklh.us> writes: > SELECT into username FROM user_table WHERE location = location_in; You're missing anything to be put into username ... regards, tom lane
believe it or not I was thinking about going to programming school next year..... On Wed, Dec 17, 2003 at 09:58:28AM -0500, Tom Lane wrote: > joseph speigle <joe.speigle@jklh.us> writes: > > SELECT into username FROM user_table WHERE location = location_in; > > You're missing anything to be put into username ... > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend -- joe speigle