Calling function from VFP changes character field to Memo
| От | Frank Cazabon |
|---|---|
| Тема | Calling function from VFP changes character field to Memo |
| Дата | |
| Msg-id | fe531f0e-ff0f-9227-c879-b875dc1201d8@gmail.com обсуждение |
| Ответы |
Re: Calling function from VFP changes character field to Memo
Re: Calling function from VFP changes character field to Memo |
| Список | pgsql-general |
Hi, I have a simple table Patients with one field FirstName of type character(30). If I SELECT FirstName From public.patients; I get back the expected character(30) field. If however I have a function defined like this CREATE OR REPLACE FUNCTION public.testfunction( ) RETURNS TABLE ( Firstname character(30) ) LANGUAGE 'plpgsql' AS $BODY$ BEGIN RETURN QUERY SELECT p.cFirstName FROM patients p; END; $BODY$; And I call: SELECT * FROM public.testFunction(); Then FirstName returns as a Memo field (similar to a Text field). Any idea what I need to do to get it to return the character(30) type? -- Frank. Frank Cazabon
В списке pgsql-general по дате отправления: