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: (view raw, whole thread or download thread mbox)
Lists: pgsql-sql

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 @ 
This allows you to send and receive SMS through your mailbox.

Powered by Outblaze


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-2017 The PostgreSQL Global Development Group