Re: [SQL] How do I remove selected words from text field?

[silly sad]

On 07/02/10 03:25, Frank Bax wrote:

Osvaldo Kussama wrote:

2010/7/1 Frank Bax :

Create some tables; then add some data:

create table t1 (i int, v varchar);
insert into t1 values(1,'A B C D');
insert into t1 values(2,'B D E F');
insert into t1 values(3,'G H I J');
insert into t1 values(4,'E');


first of all rebuild the table.
explode these strings by space char
and put into another table for convenient use

In other words
construct proper data scheme PRIOR TO USE it.

--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

[SQL] Domains based on composite types.

[Dmitriy Igrishin]

Hey all,

Is there are way to create domain based on a composite type?

Regards,
Dmitriy