Skip site navigation (1) Skip section navigation (2)

create table from regular expressions applied to rows of multiple tables

From: e-letter <inpost(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: create table from regular expressions applied to rows of multiple tables
Date: 2012-06-14 22:22:50
Message-ID: CAET1fe42Q=qOEH06qHbFXDg4+KahA7fYQeHJQ44QmTyM-R5bjQ@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Readers,

Tables contains text:

table1
text1, 10
text2, 20
text3, 30
text4, 40

table2
text2, textB 20
text3, textC 30
text5, textD 50
text6, textE 60
text7, textF 70
text8, textG 80

Is it possible to create a new table (table3) using a regular
expression (e.g. ^text*) to select rows which are of the same table
format as table2:

table3
text2, textB 20
text3, textC 30

Thanks in advance.

Responses

pgsql-novice by date

Next:From: Ken LaCrosseDate: 2012-06-15 00:29:31
Subject: Table name as a variable and/or EXECUTE and NEW.*
Previous:From: Daniel StaalDate: 2012-06-14 01:18:56
Subject: Re: coalesce in plpgsql, and other style questions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group