Procedure calling syntax with complex types

[<btober@computer.org>]

Say I have a type defined as

city (varchar, varchar(2), numeric, numeric)

What would be the syntax for calling a stored procedure defined with this
type as a parameter, i.e., something like

 CREATE FUNCTION public.city_insert(city)
  RETURNS ...

That is, I want to do something like

SELECT public.city_insert(CAST('Waterford', 'CT', 41.346853,-72.14582) AS
city);

but I don't think this syntax works.

--Berend Tober



---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org