Re: INSERTing values from usertypes how-to?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: mario(dot)splivalo(at)mobart(dot)hr
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: INSERTing values from usertypes how-to?
Date: 2006-04-27 16:34:25
Message-ID: 12063.1146155665@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Mario Splivalo <mario(dot)splivalo(at)mobart(dot)hr> writes:
> Comming back after SELECTing into usertypes, is there a nice way to
> insert data into table from usertype, in a nice way?

Try
insert into tblA values (insert_tblA.*);

This works in CVS HEAD at least, not sure how far back.

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Andreas Haumer 2006-04-27 18:09:19 Re: Porting application with rules and triggers from PG 7.4.x
Previous Message Mario Splivalo 2006-04-27 15:43:32 INSERTing values from usertypes how-to?