Skip site navigation (1) Skip section navigation (2)

inserting values into types

From: "Andrew Thorley" <andrew(dot)thorley(at)linuxmail(dot)org>
To: pgsql-sql(at)postgresql(dot)org
Subject: inserting values into types
Date: 2004-11-30 23:51:17
Message-ID: 20041130235117.E60912B2B86@ws5-7.us4.outblaze.com (view raw or flat)
Thread:
Lists: pgsql-sql
Hi,

ive generated a user defined type: CREATE TYPE qwerty_UDT AS (abc INT);

& table as: CREATE TABLE t (col1 qwerty_UDT);

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
HINT:  No function matches the given name and argument types. You may need to add explicit type casts.

which is quite confusing, does anyone have any ideas or exp with this scenario, or offer help in any way?

ty in advance :)
-- 
______________________________________________
Check out the latest SMS services @ http://www.linuxmail.org 
This allows you to send and receive SMS through your mailbox.


Powered by Outblaze

Responses

pgsql-sql by date

Next:From: Michael FuhrDate: 2004-12-01 00:17:12
Subject: Re: inserting values into types
Previous:From: Christoph HallerDate: 2004-11-30 12:08:33
Subject: Re: session-wide autocommit off

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group