Postgres Pro
Downloads
Home   >   mailing lists

[GENERAL] Extract from text id other table - PG 9.1 - Mailing list pgsql-general

From Patrick B
Subject [GENERAL] Extract from text id other table - PG 9.1
Date
Msg-id CAJNY3iu27HeC+djtmvidYyTwUpnF46dz7iDKWzdooPbKyJYbbg@mail.gmail.com
Whole thread Raw
Responses Re: [GENERAL] Extract from text id other table - PG 9.1
Re: [GENERAL] Extract from text id other table - PG 9.1
List pgsql-general
Tree view
Hi guys,

I've got tableA with 3 columns.

id(seriaL) | type(character varying(256)) | string(character varying(256))

I have the type/string value stored in another table, and from that i would like to get the id.


How can I extract, from that tablea.type_m column the tableb.id value?

Thanks
Patrick

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: [GENERAL] Redo the filenode link in tablespace
Next
From: "David G. Johnston"
Date:
Subject: Re: [GENERAL] Extract from text id other table - PG 9.1