Procedure calling syntax with complex types - Mailing list pgsql-general

From
Subject Procedure calling syntax with complex types
Date
Msg-id 65036.66.212.203.4.1083807010.squirrel@$HOSTNAME
Whole thread Raw
List pgsql-general
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



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: CHECK constraints and optimizations
Next
From: Tatsuo Ishii
Date:
Subject: error code with psql