On 31/12/2007 23:06, dvanatta wrote:
Where are all the types I've created in the object browser?
Do you see a "Types" node at all in the tree, one level beneath the
schema in which you're working? If not, you need to go to File ->
Options -> Display tab, and make sure that "Types" is checked
I realize this is a pgAdmin question but I figure most of you use it and
could help. I've executed the following code:
CREATE TYPE cart_saved_product AS
(
product_id INTEGER,
name VARCHAR(50),
price NUMERIC(10, 2)
);
it created successfully but I do not see it in the pgAdmin ob
You can have a looks at http://www.postgresql.org/docs/8.1/static/sql-createtype.htmlRegards/Shoaib
On 4/27/06, Rodrigo Sakai <[EMAIL PROTECTED]> wrote:
Hi all,
I need some help to create types to use
in a table. For exemple, I want to create:
CREATE TYPE salary_type (
value
Hi all,
I need some help to create types to use
in a table. For exemple, I want to create:
CREATE TYPE salary_type (
value
NUMERIC(10,2),
date DATE
)
CREATE TABLE employee (
num_employee
INT,
name VARCHAR(60),
salary salary_type
)
I know I ne
g to code which i have tested as stand
alone is working fine
is there any need to change locale setting for user defined data type
thanks in advance
regards
vinay
From: Stephan Szabo <[EMAIL PROTECTED]>
To: Vinay Jain <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED]
Subject: Re: [GENERAL] Cr
On Thu, 1 Apr 2004, Vinay Jain wrote:
>I am newbie so this problem may be too simple to be asked.please help me if
> any new thing to be added in following:
>
> I want to use user defined data type in User_Type(n) way
AFAIK, you cannot currently make user defined types that
take (n) fash
Hi
I am newbie so this problem may be too simple to be asked.please help me if
any new thing to be added in following:
I want to use user defined data type in User_Type(n) way
I created data type IndChar The c functions are:
/* Definaton of Data Type) */
typedef struct IndChar
{
int32
If I can't use nested tables, how can I create a
type that will be a kind of "dynamic list of structure".
regards,
Renaud THONNART
