Re: User defined type with text* field

From: Alex Pilosov <alex(at)pilosoft(dot)com>
To: Ken K <kenmail(at)telocity(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: User defined type with text* field
Date: 2001-06-30 14:58:30
Message-ID: Pine.BSO.4.10.10106301057350.7004-100000@spider.pilosoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Not yet. :)

The best way to do it currently is to create a table with these fields,
it'll create a type (with the same name as table) automatically.

Why'd you want to do that anyway?

On 30 Jun 2001, Ken K wrote:

> Hi,
>
> I am trying to create a user defined type with 2 fields
> in it, a text* and an Oid. I am not sure what size to
> use in the create type command. When I try variable
> the back end core dumps. Are there any examples for
> doing this sort of thing? Is it even doable?
>
> Thanks,
>
> Ken
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-06-30 15:02:57 Re: User defined type with text* field
Previous Message Ken K 2001-06-30 14:15:43 User defined type with text* field