Returning A Varchar From A Function - Mailing list pgsql-sql

From Richard Hurst
Subject Returning A Varchar From A Function
Date
Msg-id s11b40cb.055@kirklees.gov.uk
Whole thread Raw
List pgsql-sql
Hi 

this has been puzzling me for a few days now

I have created a function that I want to use in a database to select a
value from a table based on the value passed in.
The table is fairly simple
CREATE TABLE public.feeder_next_status
( status varchar NOT NULL, previous_status varchar, next_status varchar
) WITH OIDS;

The function is defined as 

-- Function: public.spgetnextstatus(varchar)

-- DROP FUNCTION public.spgetnextstatus(varchar);

CREATE OR REPLACE FUNCTION public.spgetnextstatus(varchar)
RETURNS varchar AS
'
select cast(next_status as varchar) 
from feeder_next_status 
where trim(status) = trim(\'$1\')
order by next_status;'
LANGUAGE 'sql' STABLE;


However when i run the query 
select spgetnextstatus('NEW')
in pgadmin
the dataoutput shows two columns
the row column shows a row number of '1' and the column header
spgetnextstatus(varchar) shows blank

I have tested the equivalent sql in the pgadmin query and it works
fine.

Hoping someone can point me inthe right direction




pgsql-sql by date:

Previous
From: Sascha Ziemann
Date:
Subject: COMMENT ON CONSTRAINT
Next
From: Fabio Ferrero
Date:
Subject: duplicate table in two databases