Re: inserting values into types

On Wed, Dec 01, 2004 at 07:51:17AM +0800, Andrew Thorley wrote:

> ive generated a user defined type: CREATE TYPE qwerty_UDT AS (abc INT);
> 
> & table as: CREATE TABLE t (col1 qwerty_UDT);

Are you using 8.0?  I don't think earlier versions allowed this.

> my prob is that when i try to insert into the type i.e: INSERT INTO t (col1) Values (qwerty_UDT(123));
> 
> i get the error:
> 
> ERROR:  function test_x(integer) does not exist

This error doesn't agree with the INSERT statement you gave -- it
should say "function qwerty_udt(integer) does not exist".  Where
does test_x() come from?  Did you type the SQL statements and/or
error messages instead of cutting and pasting?  We can see what's
happening, but it's better to paste the exact statements and output
to avoid mistakes.

> HINT:  No function matches the given name and argument types. You may need to add explicit type casts.

See the "Composite Types" documentation -- it has a section entitled
"Composite Value Input":

http://developer.postgresql.org/docs/postgres/rowtypes.html

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/