Re: [SQL] Returning A Varchar From A Function

2004-08-16 Thread George Weaver
Hi Richard, What happens if you just do: where trim(status) = trim($1) Regards, George - Original Message - From: "Richard Hurst" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 12, 2004 4:04 AM Subject: [SQL] Returning A Varchar From A Func

[SQL] Returning A Varchar From A Function

2004-08-15 Thread Richard Hurst
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