Re: [NOVICE] create table from regular expressions applied to rowsof multiple tables

#1

On Thu, 2012-06-14 at 23:22 +0100, e-letter wrote:

Quote:

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

I'm not sure I understand exactly what you're asking. Your example
table3 could also be produced by a simple inner join:

SELECT table1.col1, table2.col2
FROM table1, table2
WHERE table1.col1 = table2.col1;

But postgresql also offers a lot of regular expression functions, too.
See:

http://www.postgresql.org/docs/9.2/s...ns-string.html
http://www.postgresql.org/docs/9.2/s...-matching.html

Or post a more detailed example to show what you are looking for.

Regards,
Jeff Davis

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: [NOVICE] create table from regular expressions applied to rowsof multiple tables

mailing.database.pgsql-novice mailing.database.pgsql-novice

Re: [NOVICE] create table from regular expressions applied to rowsof multiple tables - 06-15-2012 , 06:36 PM