Re: [SQL] Custom type

2006-03-24 Thread Tom Lane
george young writes: > But not if you specify the object: > newschm3=# \d+ fffg > Table "public.fffg" > Column | Type | Modifiers | Description > +-+---+- > t | text| | > i | integer | | > This seems a bi

Re: [SQL] Custom type

2006-03-24 Thread george young
On Wed, 22 Mar 2006 13:07:33 -0800 Bryce Nesbitt <[EMAIL PROTECTED]> threw this fish to the penguins: > Terry Lee Tucker wrote: > > rnd=# \h comment > > Command: COMMENT > > Description: define or change the comment of an object > > ..I believe this is what you need. > > > Cool! > That's a

Re: [SQL] Custom type

2006-03-22 Thread Daniel Caune
> > Hi, > > > > How can I enter description for my custom types? > > > > \dT provides information such as schema, name, and description for all > > the registered types and custom types. I would like to provide a > > description for each custom type I create. > > > > Thanks, > > > > > > -- > > D

Re: [SQL] Custom type

2006-03-22 Thread Bryce Nesbitt
Terry Lee Tucker wrote: > rnd=# \h comment > Command: COMMENT > Description: define or change the comment of an object > ..I believe this is what you need. > Cool! That's a great feature. Though it would be even nicer if the comment showed when you "\d" a table:: stage=# comment on table

Re: [SQL] Custom type

2006-03-22 Thread Terry Lee Tucker
On Wednesday 22 March 2006 03:25 pm, Daniel Caune saith: > Hi, > > How can I enter description for my custom types? > > \dT provides information such as schema, name, and description for all > the registered types and custom types. I would like to provide a > description for each custom type I cr

[SQL] Custom type

2006-03-22 Thread Daniel Caune
Hi, How can I enter description for my custom types? \dT provides information such as schema, name, and description for all the registered types and custom types. I would like to provide a description for each custom type I create. Thanks, -- Daniel CAUNE Ubisoft Online Technology (514) 4090

Re: [SQL] Custom type where not all elements are comparable

2004-07-05 Thread Peter Eisentraut
Markus Bertheau wrote: > Is it possible to define or implement a type in PostgreSQL not all > values of which are comparable to each other? In particular I'm > thinking of a duration type similar to the XML Schema duration > type[1]. For example P2D (2 days) is less than P4D (4 days), but P1M > (1

Re: [SQL] Custom type where not all elements are comparable

2004-07-05 Thread Tom Lane
Markus Bertheau <[EMAIL PROTECTED]> writes: > Is it possible to define or implement a type in PostgreSQL not all > values of which are comparable to each other? Certainly, as long as you don't expect to be able to btree-index it, sort it, or DISTINCT it. (In theory we could probably handle DISTIN

[SQL] Custom type where not all elements are comparable

2004-07-05 Thread Markus Bertheau
Hi, Is it possible to define or implement a type in PostgreSQL not all values of which are comparable to each other? In particular I'm thinking of a duration type similar to the XML Schema duration type[1]. For example P2D (2 days) is less than P4D (4 days), but P1M (1 month) and P30D (30 days) ar